Hi,
I ran a query on two supposedly similarly configured 9.6.8 databases but
got two different timings. One ran three times faster than the other.
The explain plans on both systems look the same except for the Buckets and
Batches. Can someone explain what that means and what configuration
Hi,
I can find sequences owned by a schema from information_schema.sequences
and pg_class but how do I find sequences owned by a user/role? What pg
table should I be looking at?
Thanks.
Charlin
Hi,
We will be developing three new applications in PostgreSQL, each having its
own database instance running on different hosts. We will only have one
schema per Postgres instance. The data is read-write only by one
application/schema in the DB instance and the data is published to other
Thanks Laurenz. That works.
On Tue, Apr 24, 2018 at 4:00 PM, Laurenz Albe <laurenz.a...@cybertec.at>
wrote:
> Charlin Barak wrote:
>
> > We will be developing three new applications in PostgreSQL, each having
> its own
> > database instance running on different h
103 48299 \N G 3 45
...
...
On Fri, Mar 16, 2018 at 2:06 PM, Pavel Stehule <pavel.steh...@gmail.com>
wrote:
>
>
> 2018-03-16 18:12 GMT+01:00 Charlin Barak <charlinba...@gmail.com>:
>
>> Hi,
>> I'm using ora2pg to migrate our Oracle database to
Hi,
I'm using ora2pg to migrate our Oracle database to Postgres. I was able to
generate the data file using TYPE=COPY but when I attempted to load the
file via psql, I got lots of "invalid command \N" errors. The resolution on
the internet was not clear and was not ora2pg related. How do I
Hi,
When migrating from Oracle number(10,3) to PostgreSQL, is numeric(10,3)
ideal or should I consider some other data types?
Thanks.
Charlin
Thanks Stephen. Something for me to consider.
Charlin
On Wed, May 1, 2019 at 9:25 AM Stephen Frost wrote:
> Greetings,
>
> * Charlin Barak (charlinba...@gmail.com) wrote:
> > When migrating from Oracle number(10,3) to PostgreSQL, is numeric(10,3)
> > ideal or should I con