Postgres Pro
Downloads
Home   >   mailing lists

Re: How to improve insert speed with index on text column - Mailing list pgsql-performance

From Saurabh
Subject Re: How to improve insert speed with index on text column
Date
Msg-id 51f4fd78-e683-4c24-a7fa-5cdb0ef21693@lr19g2000pbb.googlegroups.com
Whole thread Raw
In response to Re: How to improve insert speed with index on text column  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: How to improve insert speed with index on text column  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
Tree view 
Kelvin,

My intention to keep autovacuum as off is bulk loading only. I was
thinking after bullk load I will change it.

I changed wal_buffer from 5MB to 16MB but I got same performance that
I got with 5MB (even less).

Thanks,
Saurabh

pgsql-performance by date:

Previous
From: "Marc Mamin"
Date:
Subject: text search: tablescan cost for a tsvector
Next
From: Ofer Israeli
Date:
Subject: Inserts or Updates