ve to TRUNCATE TABLE I tried to CREATE and DROP a table, but
that wasn't any faster.
Sincerely,
Adriaan van Os
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
Gregory Stark wrote:
That's strange. Deleting should be the *quickest* operation in Postgres. Do
you perchance have foreign key references referencing this table?
No.
Do you have any triggers?
No.
Tom Lane wrote:
Adriaan van Os <[EMAIL PROTECTED]> writes:
Surprisingly,
ow at creating and deleting files, see
<http://en.wikipedia.org/wiki/XFS> and <http://everything2.com/index.pl?node_id=1479435>.
Regards,
Adriaan van Os
---(end of broadcast)---
TIP 4: Have you searched our list archives?
ta takes 1
ms in one test and takes 532 ms in another one. The database has no foreign keys.
Based on these results, I still believe there is a problem in Postgres.
Regards,
Adriaan van Os
---(end of broadcast)---
TIP 3: Have you
Tom Lane wrote:
Adriaan van Os <[EMAIL PROTECTED]> writes:
I started another test. I copied an existing database (not very large,
35 tables, typically a few hundred up to a few thousand records) with
CREATE DATABASE testdb TEMPLATE mydb and started to remove random
tables from testdb wit
as much as those of TRUNCATE TABLE. Your observations on the time needed to
open a file confirm that, I think.
In my test databases, autovacuum is off.
Regards,
Adriaan van Os
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner w
't be cleaned up).
So, how does one (temporarily) disable WAL logging ? Or, for example, disable WAL logging for a
temporary table ?
Regards,
Adriaan van Os
---(end of broadcast)---
TIP 6: explain analyze is your friend
port ?
Regards,
Adriaan van Os
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
tovac itself doesn't create or delete any files, so what's
up here?
Have you ruled out checkpoints as the culprit?
That's a good question. I will do some more tests, but I also suspect fsync
"cascading"
<http://www.uwsg.iu.edu/hypermail/linux/kernel/0708
