On Tue, Jun 25, 2019 at 11:49:03AM -0400, Hugh Ranalli wrote:
> I'm hoping people can help me figure out where to look to solve an odd
> PostgreSQL performance problem.
What kernel? Version? OS?
If Linux, I wonder if transparent hugepages or KSM are enabled ? It seems
possible that truncating
I didn't say do it all the time, I said if he hasn't done it already he
should try that as a way of ensuring the database server's understanding of
the data as it stands is correct. Otherwise there isn't enough information
to suggest other solutions as there is no description of the operating
syste
On Tue, Jun 25, 2019 at 10:55:22PM +0700, Benjamin Scherrey wrote:
> Have you done a VACUUM ANALYZE FULL on your database? This needs to be done
> periodically to inform the server of the statistics of how the data and
> relations are distributed across the database.
I think this is wrong.
VACUUM
Have you done a VACUUM ANALYZE FULL on your database? This needs to be done
periodically to inform the server of the statistics of how the data and
relations are distributed across the database. Without this bad assumptions
by the planner can cause degradation of performance. Also, if you are using
I'm hoping people can help me figure out where to look to solve an odd
PostgreSQL performance problem.
A bit of background: We have a client with a database of approximately 450
GB, that has a couple of tables storing large amounts of text, including
full HTML pages from the Internet. Last fall, t
On Sun, Jun 23, 2019 at 10:21 AM Rick Otten
wrote:
> I'm not sure where else to look, so I'm asking here for tips.
>
> I have a table in a remote (Heroku-managed) postgresql database (PG 10.7).
>
> On the other end, (PG 11.3) I have a foreign table configured with a
> materialized view in front o
> ts=# explain SELECT * FROM eric_enodeb_cell_metrics WHERE start_time
> BETWEEN '2019-01-01 04:00' AND '2019-01-01 05:00' OR start_time BETWEEN
> '2019-01-02 04:00' AND '2019-01-02 05:00'
Maybe it's because of the implicit usage of the local timezone when the strings
are cast to (timestamp with
