We have two tables, both have ~36 partitions.
This is my first query, which attempts to join the parent tables on the
columns that have been used to create multi-column indexes for all
partitions (multi-column indexes defined on session_id, detail_id in that
order):
*PostgreSQL version : 10*-- *q
d 80 GB of dead rows.
Thanks
On Tue 16 Oct, 2018, 20:23 Adrian Klaver, wrote:
> On 10/16/18 7:29 AM, Shrikant Bhende wrote:
> > Hi Adrian,
> >
> > Its a PostgreSQL binary and installer was downloaded from enterprisedb
> site.
> > Binary version : psql (PostgreSQL
Hi Adrian,
Its a PostgreSQL binary and installer was downloaded from enterprisedb site.
Binary version : psql (PostgreSQL) 9.6.10
Command to restore the dump is :
./psql -p 5434 -d cloud -f
Thanks
On Tue, Oct 16, 2018 at 2:55 AM Adrian Klaver
wrote:
> On 10/15/18 8:10 AM, Shrikant Bhe
Klaver
wrote:
> On 10/15/18 8:04 AM, Shrikant Bhende wrote:
> > Hi Adrian,
> >
> > There is no explicit client its just simple restore using psql with all
> > default settings required.
>
> psql is the client. Where is it running relative to the server locally
>
Hi Adrian,
There is no explicit client its just simple restore using psql with all
default settings required.
On Mon, Oct 15, 2018 at 6:50 PM Adrian Klaver
wrote:
> On 10/15/18 5:36 AM, Shrikant Bhende wrote:
> > Hi Team,
> >
> > I am trying to restore the backup into post
mpall
using the PostgreSQL binaries and trying to restore the same.
PPAS :: 9.3
PostgreSQL : 9.6
O/S :: Centos 6.6
Thanks and Regards.
--
Shrikant Bhende
+91-9975543712
