ConanTheGerbil's user avatar
ConanTheGerbil's user avatar
ConanTheGerbil's user avatar
ConanTheGerbil
  • Member for 6 years, 4 months
  • Last seen more than a week ago
11 votes
4 answers
13k views

How to identify the ranges over which a postgres table was partitioned?

5 votes
1 answer
4k views

Postgres, two tables use the same sequence, how to delete one?

5 votes
1 answer
13k views

Postgres performance testing, caching and flushing

5 votes
1 answer
3k views

Changing POSTGRES column datatype - should I drop indexes and then re-create?

5 votes
1 answer
16k views

Postgres - how to tell when the last VACUUM FULL was run?

4 votes
1 answer
4k views

Meaning of precision 1, scale 0 in error message?

4 votes
1 answer
8k views

Changing a column datatype from INT to BIGINT

4 votes
1 answer
7k views

How to free postgres space after a DELETE without VACUUM

4 votes
3 answers
4k views

Postgres - how much space is required to perform a VACUUM

4 votes
1 answer
603 views

changing tablespace seems to waste space

3 votes
3 answers
27k views

How to compact the current MS Access database from VBA function

3 votes
1 answer
2k views

Distributing a single table across multiple disks of different performance?

3 votes
1 answer
590 views

Postgres - caching of recently inserted data?

3 votes
1 answer
1k views

Postgres – how to alter the WHERE clause of a postgres index

3 votes
1 answer
4k views

Checking space availability before a VACUUM FULL (postgres)

2 votes
0 answers
1k views

How to VACUUM FULL a single partition without stalling the parent?

2 votes
2 answers
6k views

Writing a query that will quit if there's a lock on a target row

2 votes
1 answer
2k views

Adding a CHECK constraint doesn't improve performance of ATTACH PARTITION on postgres table

2 votes
1 answer
863 views

How to run a trigger on existing rows

2 votes
2 answers
3k views

Postgres - What is a vacuum delay?

1 vote
1 answer
721 views

Copying a Postgres table and using the same name index names

1 vote
1 answer
338 views

Postgres - most efficient way of storing a small number [duplicate]

1 vote
0 answers
163 views

Persuading POSTGRES to use a sensible INDEX

1 vote
0 answers
232 views

How to direct psql errors to powershell log file?

1 vote
1 answer
181 views

Moving records from one table to another - a few records at a time

1 vote
0 answers
60 views

What circumstances will cause a postgres 'unlogged' table to lose data?

1 vote
0 answers
51 views

Postgres - now to optimise a table for high frequency INSERTs?

1 vote
1 answer
375 views

Searching for a close numeric match on spatial coordinates

1 vote
2 answers
3k views

Does the 'ORDER BY' clause of a subquery pass through to the main results (POSTGRES)

1 vote
1 answer
1k views

How to tell how long autovacuum took to vacuum a postgres table?