On 2018-Aug-05, Ron wrote:
> For columns of type bytea which store image data (PDFs, JPGs, etc) would it
> speed up the ANALYZE process to SET STATISTICS = 0?
Yes. I'd suggest also looking at ALTER TABLE ... SET STORAGE to avoid
having Postgres try to compress those columns, which is useless was
Hi,
On Thu, 2018-08-02 at 08:53 +0300, Alexandru Lazarev wrote:
> I saw on URL there are PG 9.6.8 and 9.6.9 - Are there maintained only
> latest 2 build releases?
Yes, older releases are deleted automagically.
Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Cons
Hello all,
I'm trying to write queries with conditional JOINs. The goal is to guard
expensive views by checking some conditions first and not execute the view at
all if any of the conditions fail. Think along the lines of REST, like Not
Authorized or Not Modified.
My problem is that the Postgr
Ron writes:
> For columns of type bytea which store image data (PDFs, JPGs, etc) would it
> speed up the ANALYZE process to SET STATISTICS = 0?
Should do, though I'm not sure how much of an effect you'd see.
regards, tom lane
On 2018-08-04 13:34:04 -0600, Brent Kerby wrote:
> On Postgres 10.3 (on AWS RDS), I am running logical decoding using the
> test_decoding output plugin, and every few minutes I am seeing pauses in
> the stream, unrelated to any large transactions. About once every hour or
> two, the pause is long e
On Postgres 10.3 (on AWS RDS), I am running logical decoding using the
test_decoding output plugin, and every few minutes I am seeing pauses in
the stream, unrelated to any large transactions. About once every hour or
two, the pause is long enough that the database disconnects my client due
to exce