Re: Row estimates for empty tables

On Fri, 24 Jul 2020 at 16:01, Christophe Pettus wrote: > I realize I've never quite known this; where does the planner get the row > estimates for an empty table? Example: We just assume there are 10 pages if the relation has not yet been vacuumed or analyzed. The row estimates you see are the

Row estimates for empty tables

I realize I've never quite known this; where does the planner get the row estimates for an empty table? Example: psql (11.8) Type "help" for help. xof=# CREATE TABLE t (i integer, t text, j integer); CREATE TABLE xof=# VACUUM ANALYZE t; VACUUM xof=# EXPLAIN ANALYZE SELECT * FROM t;

Re: Slow or Cannot Connect to PostgreSQL Instance Service on Windows 10

On 7/22/20 4:49 PM, Surya Widyanto wrote: On 23-07-2020 06:12, Rob Sargent wrote: On Jul 22, 2020, at 4:58 PM, Surya Widyanto > wrote: On 23-07-2020 05:26, Adrian Klaver wrote: On 7/22/20 10:24 AM, Surya Widyanto wrote: Hi, I have PostgreSQL v12.3 (x64) installed

ERROR: out of overflow pages in hash index

Anyone know if this can be remedied? ERROR: out of overflow pages in hash index This occurred while waiting for a hash index to be created on a 1,580 GB table (Postgres 11.7). We have > 30 TB of space free. Here's the line where I think it gets triggered. https://github.com/postgres/post

Re: Pgpool in docker container

Hello, > Hi All, > > Planning to build standalone postgres and with pgpool as connection pooler > in docker containers. > Shall we try option like installing pgpool in one docker container and > postgres in another docker container, is it possible? Yes. It is possible to install Pgpool-II and

Re: HA setup with pg pool in docker

Hello, On Wed, 22 Jul 2020 13:29:31 +0800 Vasu Madhineni wrote: > We are planning to build a HA setup with pgpool in docker, Could you please > let us know prerequisites for it. > > 1. How many servers are needed for this?, can we plan with 2 servers like > below config. >Primary instance a

Re: Problem with pg_service.conf

On Thu, Jul 23, 2020 at 6:12 AM Michał Lis wrote: > Hello, > > The server is located in the lan and runs on Windows 7x64 Ultimate. > On this server I created pg_service.conf file and set the environment > variable of PGSERVICEFILE. > The server software (postgres) doesn't use PGSERVICEFILE, only

Re: Problem with pg_service.conf

Hello, The server is located in the lan and runs on Windows 7x64 Ultimate. On this server I created pg_service.conf file and set the environment variable of PGSERVICEFILE. The client is an other computer with Windows 7x64 Pro. It has no access to local folders on the server (especially to the

pglogical, replication_slots and going back in time

i was wondering if there is a way to manually manipulate the wal location from where a pglogical slave resumes the replication process. Let's imagine the following scenario. There is a pglogical slave running on an operating system that allows hourly snapshots. If at 08:00 we decide we need to go

Re: How to enable TDE on Postgresql 12.3 deployed using Kubernetes

Hello all, Pls suggest if anyone has any reference of a docker image with TDE enables Postgre 12.3? On Wed, Jul 15, 2020 at 3:01 PM Samarendra Sahoo wrote: > If there are any references or you have done, could you pls share steps? > > Thanks > >