All Questions
3 questions
0
votes
0
answers
2k
views
EXPLAIN (BUFFER,ANALYZE) understading
I am using PostgreSQL 9.3 Can some one help me what i can do to improve this. The max number of records in db table is approx 5000 to 7000 varies daily basis. shared_buffers setting in PGsql DB is =...
- 139
47
votes
2
answers
38k
views
How to understand an EXPLAIN ANALYZE
I am not very familiar with looking at EXPLAIN ANALYZE results, I have a huge problem with my queries being too slow. I have tried to read up on how to interpret results from an explain queries, but ...
- 8,875
27
votes
2
answers
9k
views
Does the order of columns in a Postgres table impact performance?
In Postgres does the order of columns in a CREATE TABLE statement impact performance? Consider the following two cases:
CREATE TABLE foo (
a TEXT,
B VARCHAR(512),
pkey INTEGER ...
- 62.9k