ot; btree (z, dt)
Triggers:
_ctele_denyaccess_5 BEFORE INSERT OR DELETE OR UPDATE ON calls FOR EACH
ROW EXECUTE PROCEDURE _ctele.denyaccess('_ctele')
Pozdrawiam
Marcin Mańk
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
machine is low traffic.
Greetings
Marcin Mańk
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
> I'd run pg_dump | gzip > sqldump.gz on the old system. That took about
> 30 hours and gave me an 90GB zipped file. Running
> cat sqldump.gz | gunzip | psql
> into the 8.1 database seems to take about the same time. Are there
> any tricks I can use to speed this dump+restore process up?
>
>
1 | 3811413
> (1 row)
PG assumes that the "wbc.poznan.pl" rows are all over the range of
ids, which seems not to be the case. There is no sense of cross-column
correlation in the planner currently.
You are going to have to resort to some more or less cute hacks, like
making an index o
> DELETE FROM B
> WHERE r_id IN (SELECT R.id
> FROM R, B
> WHERE r.end_date < (NOW() - (interval '1 day' * 30))
> AND r.id = b.r_id
>
How about:
DELETE FROM B
WHERE r_id IN (SELECT distinct R.id
FROM R WHERE r.end_date < (NOW() - (interval '1 day' * 30))
?
Greetings
Marcin
on time.
> i also change the connection string (i remove host and port) and nothing
> changed.
The first query using a text search config loads the dictionaries, so
it is slower, and that's why the following queries are faster. I think
your PHP persistent connections don't work to
ERS) SELECT title, url, ts_rank_cd(vector, query)
AS rank FROM links, to_tsquery('english', 'risk') query WHERE query @@
vector ORDER BY rank DESC LIMIT 10;
with varying queries, and post the results. This will show how many
blocks are are read from shared buffers, and ho
best plan here, and it won't get chosen with low work_mem .
Regards
Marcin Mańk
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance