Re: Bulk Insert into PostgreSQL
| От | Srinivas Karthik V |
|---|---|
| Тема | Re: Bulk Insert into PostgreSQL |
| Дата | |
| Msg-id | CAEfuzeRYxfKx8BS7GODWLLLBOoRU3r3egi1SvMqJ0cyWyFTY6A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Bulk Insert into PostgreSQL (Peter Geoghegan <pg@bowt.ie>) |
| Список | pgsql-hackers |
Thanks for the link!
Alternatively, when I am trying to create an index on a column of a table which is of size 400 GB, it is taking roughly 7 hrs. The index is created only on one column which is not a primary key. The query I am using is, create index on table (colname). I request your valuable suggestions for the same. The configuration parameters are:
shared_buffers =12GB
maintainence_work_mem = 8GB
work_mem = 1GB
fsync = off
synchronous_commit = off
checkpoint_segments = 256
checkpoint_timeout = 1h
checkpoint_completion_target = 0.9
checkpoint_warning = 0
checkpoint_timeout = 1h
checkpoint_completion_target = 0.9
checkpoint_warning = 0
autovaccum = off
Regards,
Srinivas Karthik
On Wed, Jul 4, 2018 at 10:27 PM, Peter Geoghegan <pg@bowt.ie> wrote:
On Tue, Jul 3, 2018 at 4:34 PM, Srinivas Karthik V
<skarthikv.iitb@gmail.com> wrote:
> @Peter: I was indexing the primary key of all the tables in tpc-ds. Some of
> the fact tables has multiple columns as part of the primary key. Also, most
> of them are numeric type.
Please see my mail to -hackers on suffix truncation:
https://postgr.es/m/CAH2-Wzn5XbCzk6u0GL+ uPnCp1tbrp2pJHJ=3bYT4yQ0_ zzHxmw@mail.gmail.com
Perhaps this is related in some way, since in both cases we're talking
about a composite index on varlena-type columns, where the types have
expensive comparisons.
--
Peter Geoghegan
В списке pgsql-hackers по дате отправления: