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

2020-02-20 Thread Daulat Ram
You mean we can have only single default tablespace for a database but the database objects can be created on different-2 tablespaces? From: amul sul Sent: Friday, February 21, 2020 11:48 AM To: Daulat Ram Cc: pgsql-gene...@lists.postgresql.org; pgsql-performance@lists.postgresql.org Subject:

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

2020-02-20 Thread amul sul
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.

2020-02-20 Thread Daulat Ram
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 Postgres Tablespacs? Thanks, From: amul sul Sent: Friday,

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

2020-02-20 Thread amul sul
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.

2020-02-20 Thread Daulat Ram
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 '/mnt/pgdatatest/test/pgdata/conn_tbs'; 2. Create database test

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

2020-02-20 Thread David G. Johnston
Please pick a single list to post to. Performance seems like the unnecessary one here. On Thu, Feb 20, 2020 at 10:34 PM Daulat Ram wrote: > Can we have multiple tablespaces with in a database in postgres? > I fell as if I'm missing something in your question given the presence of the "CREATE

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

2020-02-20 Thread amul sul
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

Can we have multiple tablespaces with in a database.

2020-02-20 Thread Daulat Ram
Hi Team, Can we have multiple tablespaces with in a database in postgres? Can we have a table on different tablespace same as Oracle? Thanks,

Re: tablespace to benefit from ssd ?

2020-02-20 Thread Jeff Janes
On Tue, Feb 18, 2020, 11:42 PM Nicolas PARIS wrote: > However the server has a large amount of ram > memory and I suspect all of those indexes are already cached in ram. > Then there may be no benefit to be had. > > I have read that tablespaces introduce overhead of maintenance and >

Re: SubtransControlLock and performance problems

2020-02-20 Thread Lars Aksel Opsahl
Hi >From: Alvaro Herrera >Sent: Wednesday, February 19, 2020 4:23 PM >To: Lars Aksel Opsahl >Cc: Laurenz Albe ; Pavel Stehule >; Tom Lane ; >pgsql-performance@lists.postgresql.org >Subject: Re: SubtransControlLock and performance problems > >On