Re:

On Tue, May 17, 2022 at 9:12 AM Rama Krishnan wrote: > > Hi All, > > How to install pg_repack and use? Check this: https://reorg.github.io/pg_repack/ Regards, Amul

Re: How to write such a query?

See prepare statement : https://www.postgresql.org/docs/current/sql-prepare.html On Thu, Jan 6, 2022 at 12:10 PM Igor Korot wrote: > > Hi, ALL, > In SQLite you can write: > > SELECT a, b, c FROM foo WHERE id = :id; > > where ":id" is the named parameter. > > The query above is similar to > >

Re:

On Tue, Dec 14, 2021 at 5:30 PM Dennis wrote: > > Hi, > > Can I add custom sqls for regression tests (pg_regress) ? > If it can be added how? > Check this: https://wiki.postgresql.org/wiki/Regression_test_authoring Regards, Amul

Re: Max connections reached without max connections reached

On Mon, Dec 6, 2021 at 6:11 AM James Sewell wrote: >> >> Agreed with both points. What about we add, subxid count and overflow >> status in LocalPgBackendStatus and through that, we can show in >> pg_stat_activity. That way we don't have to report it ever and >> whenever the user is running

Re: Sizing PostgreSQL VM server sizing

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server might help. Regards, Amul On Tue, Aug 11, 2020 at 9:49 PM Samarendra Sahoo wrote: > > Dear all, > We are getting ready to install in production and would like to know what are > key considerations and how do we use them to

Re: HASH partitioning not working properly

On Fri, Jun 19, 2020 at 3:50 PM Srinivasa T N wrote: > > > > On Fri, Jun 19, 2020 at 3:09 PM Amul Sul wrote: >> >> On Fri, Jun 19, 2020 at 1:28 PM Srinivasa T N wrote: >> > >> > On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe >> > wrote: >&

Re: HASH partitioning not working properly

On Fri, Jun 19, 2020 at 1:28 PM Srinivasa T N wrote: > > On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe > wrote: >> >> On Fri, 2020-06-19 at 12:12 +0530, Srinivasa T N wrote: >> > On Fri, Jun 19, 2020 at 11:44 AM David Rowley wrote: >> > > On Fri, 19 Jun 2020 at 17:42, Srinivasa T N wrote: >>

Re: Table partitioning with sequence field in postgresql12

On Thu, Jun 18, 2020 at 12:22 PM Srinivasa T N wrote: > > Hi, >I have a parent table with one of the field as ""gid" int4 DEFAULT > nextval('"ami_smart_new".aoi_boundary_gid_seq'::regclass)". > >I create child tables which inherit parent and use hash partition. When I > directly insert

Re: Table partitioning with sequence field in postgresql12

On Thu, Jun 18, 2020 at 12:00 PM Srinivasa T N wrote: > > Hi, >Partitioning of a table with sequence id as one of its fields is supported > in postgresql12? > Could you please elaborate on your case a bit more? Regards, Amul

Re: Can we have multiple tablespaces with in a database.

On Fri, Feb 21, 2020 at 12:48 PM Daulat Ram wrote: > What are the differences between Oracle and Postgres tablespace. > > I hope this[1] wiki page will help you. > Can we assign tablespace during Postgres schema creation . As I know in > Oracle we assign the tablespace during user/schema

Re: Can we have multiple tablespaces with in a database.

On Fri, Feb 21, 2020 at 11:53 AM Daulat Ram wrote: > That will be great if you share any doc where it’s mentioned that we > can’t use multiple tablespace for a single database. I have to assist my > Dev team regarding tablespaces. > > > > Also , what are the differences between Oracle and

Re: Can we have multiple tablespaces with in a database.

On Fri, Feb 21, 2020 at 11:31 AM Daulat Ram wrote: > Hi Amul , > > Please share the examples how we can create no. of tablespaces for a > single database and how we can use them. > > As I know we can create database on tablespace > >1. CREATE TABLESPACE conn_tbs OWNER enterprisedb LOCATION >

Re: Can we have multiple tablespaces with in a database.

On Fri, Feb 21, 2020 at 11:04 AM Daulat Ram wrote: > Hi Team, > > > > Can we have multiple tablespaces with in a database in postgres? > > Yes. > Can we have a table on different tablespace same as Oracle? > Yes -- specify TABLESPACE option while creating that table. Regards, Amul

Re: connection error

On Fri, Sep 7, 2018 at 5:10 PM amul sul wrote: > > Do you have following entry as well? > > # IPv6 local connections: > hostall all ::1/128 trust > > I hope "listen_addresses " in postgresql.conf is on default setting. &g

Re: connection error

Do you have following entry as well? # IPv6 local connections: hostall all ::1/128 trust I hope "listen_addresses " in postgresql.conf is on default setting. Regards, Amul Sul On Fri, Sep 7, 2018 at 4:08 PM Sonam Sharma wrote: > > get

Re: PG11 Hash partitioning and null values in the partition key

On Fri, Jul 13, 2018, 7:35 PM Daniel Westermann < daniel.westerm...@dbi-services.com> wrote: > Hi, > > given this setup: > > create table part2 ( a int, list varchar(10) ) partition by hash (a); > create table part2_1 partition of part2 FOR VALUES WITH (MODULUS 3, > REMAINDER 0); > create table

Re: How do I copy an element of composite type array into csv file?

On Wed, May 23, 2018 at 2:05 PM, a <372660...@qq.com> wrote: > Hi suppose I have composite type and table > > create type A as( > x float8, > y float8 > ); > > create table B( > Ay A[] > ); > > insert into B > values(array[ > (1,2)::A, > (3,4)::B] > ); > > Now I would like to

Re: Can postgresql ignore DST ?

How about storing timestamp without timezone[1]? 1] https://www.postgresql.org/docs/current/static/datatype-datetime.html Regards, Amul On Thu, Dec 14, 2017 at 10:19 AM, Venkata B Nagothi wrote: > Hi All, > > I have a question regarding PostgreSQL time zones and daylight

Re: [GENERAL] Reset Sequence number

Firstly, anonymous procedures are not supported in PostgreSQL, you need to embed this block in a plpgsql function[1] body & call that function if you want reset sequence value manually, or you could use CYCLE option[2] of a sequence to auto reset. 1]