I'm running 2 tests now, one, where I'm doing the traditional indexing, in
sequence. The server isn't doing anything else, so I should get pretty accurate
results.
Test 2 will win all the create index sessions in separate sessions in parallel
(echo "create index ..."|psql ... & ) once the 'seria
Chris Ruprecht writes:
> I have a table that I need to rebuild indexes on from time to time (records
> get loaded before indexes get build).
> To build the indexes, I use 'create index ...', which reads the entire table
> and builds the index, one at a time.
> I'm wondering if there is a way to
I have a table that I need to rebuild indexes on from time to time (records get
loaded before indexes get build).
To build the indexes, I use 'create index ...', which reads the entire table
and builds the index, one at a time.
I'm wondering if there is a way to build these indexes in parallel w
Dne 31.3.2011 19:26, Laszlo Nagy napsal(a):
> For this query:
>
> select pp.id,pp.product_id,pp.selling_site_id,pp.asin
> from product_price pp
> where
> (pp.asin is not null and pp.asin<>'')
> and (pp.upload_status_id<>1)
> and pp.selling_site_id in (8,7,35,6,9)
> and (pp.last_od < 'now'::timesta
> Hi,
>
> I am trying to tune a query that is taking too much time on a large
> dataset (postgres 8.3).
>
Hi, run ANALYZE on the tables used in the query - the stats are very off,
so the db chooses a really bad execution plan.
Tomas
--
Sent via pgsql-performance mailing list (pgsql-performance
