Ah, thanks. I am not a developer of PostgreSQL. I am a developer in PostgreSQL.
:) And I see two hash indexes on the same data and one of them 43 times bigger
then other, this looked like something terribly wrong. Just free idea how to
considerably improve your product.
> 13 нояб. 2018 г., в 22
Eh, I checked, you are right. Something terribly wrong with hash index in
PostgreSQL. But there are another hash index gin(jsonb_path_ops), may be
correctly say gin+hash index. Looked like it is the best for this purpose.
> 26 окт. 2018 г., в 19:27, Jeff Janes написал(а):
>
> On Thu, Oct 25, 2
Well your information needs some update.
- On AIX, IBM had no issues selling Oracle, a rival to DB2.
- IBM Global Services, a consulting unit was the single biggest sales force for
Oracle Installations outside
Oracle. In other words, they ended up using Oracle for projects done by
IGM-GS more
Ravi Krishna-9 wrote
> Well your information needs some update.
>
> - On AIX, IBM had no issues selling Oracle, a rival to DB2.
> - IBM Global Services, a consulting unit was the single biggest sales
> force for Oracle Installations outside
> Oracle. In other words, they ended up using Oracle fo
On 11/13/18 11:04 PM, Sachin Kotwal wrote:
Hi PostgreSQL lovers,
I heard news that Redhat is going to acquired by IBM. IBM has its on
database. And they have history of selling applications with their own
hardware (software and hardware together).
As per my knowledge PostgreSQL community has
Hi
I d'like my user be able to select on any new table from other users.
> ALTER DEFAULT PRIVILEGES FOR ROLE "theowner1" IN SCHEMA "myschema" GRANT
> select ON TABLES TO "myuser"
> ALTER DEFAULT PRIVILEGES FOR ROLE "theowner2" IN SCHEMA "myschema" GRANT
> select ON TABLES TO "myuser"
>
On Tue, 13 Nov 2018, Adrian Klaver wrote:
Just realized the question I should have asked is:
How did you get the pg_dumpall file processed by Postgres?
In other words how did you do it without a password?
As user postgres I entered the command
$ psql -f dump-all.sql
In any case, I need to
On 11/14/18 6:58 AM, Rich Shepard wrote:
On Tue, 13 Nov 2018, Adrian Klaver wrote:
Just realized the question I should have asked is:
How did you get the pg_dumpall file processed by Postgres?
In other words how did you do it without a password?
As user postgres I entered the command
$ psq
Rich Shepard writes:
>ps ax | grep postgres
> shows a number of processes, but psql tells me there's no server running,
> and there is no postmaster.opts or postmaster.pid in the data directory.
Perhaps those are associated with some other data directory?
You could try using lsof on one of t
On Wed, 14 Nov 2018, Tom Lane wrote:
Perhaps those are associated with some other data directory?
Tom/Adrian,
I think that I FUBARed the upgrade from 10.3 to 11.1. I've removed both
packages and am rebuilding 11.1. I'll install it, run initdb on it, then
re-run pg_dumpall on the 10.5 data d
On 11/14/2018 08:19 AM, Nicolas Paris wrote:
Hi
I d'like my user be able to select on any new table from other users.
ALTER DEFAULT PRIVILEGES FOR ROLE "theowner1" IN SCHEMA "myschema" GRANT select ON
TABLES TO "myuser"
ALTER DEFAULT PRIVILEGES FOR ROLE "theowner2" IN SCHEMA "myschema"
On Wed, 14 Nov 2018, Rich Shepard wrote:
I think that I FUBARed the upgrade from 10.3 to 11.1. I've removed both
packages and am rebuilding 11.1. I'll install it, run initdb on it, then
re-run pg_dumpall on the 10.5 data directory on the old desktop. Starting
from scratch on this new desktop wil
I'm trying to get the <-> operator to recognize a trigram index (GIST) I've
set on a table. Using `EXPLAIN VERBOSE` I can see the query engine ignoring
the trigram index when using the `<->` operator. However if I use the `%`
operator, the index is found and used. Can you explain why this is
happen
Hello;
I've written a Java program which uses Postgresql via JDBC. The program works
fine on all RedHat systems I've tested except one, where it yields an
UnsatisifiedLinkError. Here is the stack trace:
sun.misc.VM.latestUserDefinedLoader0(Native
Method)
sun.misc.VM.latestUserDefinedLoader(VM
On 11/14/18 9:25 AM, dcl...@cinci.rr.com wrote:
Hello;
I've written a Java program which uses Postgresql via JDBC. The program works
fine on all RedHat systems I've tested except one, where it yields an
UnsatisifiedLinkError. Here is the stack trace:
sun.misc.VM.latestUserDefinedLoader0(Nat
Adrien Nayrat wrote:
> With 17 million LO, it could eat lot of memory ;)
Yes it does.
I did several tests and here are my observations.
First memory settings are:
shared_buffers = 3GB
work_mem = 32Mb
maintenance_work_mem = 1GB
effective_cache_size = 9MB
bytea_output = 'escape'
The largest LO is
wow,
it was right under my nose.
Thank you very much !
Cheers,
Remi-C
Le mar. 13 nov. 2018 à 19:00, Tom Lane a écrit :
> =?UTF-8?Q?R=C3=A9mi_Cura?= writes:
> > So the pgpointcloud store sometimes very large groups of points into one
> > row (TOASTED), something along few kB to few MB. TOAST wou
On Wed, Nov 14, 2018 at 10:05:51AM -0600, Ron wrote:
> On 11/14/2018 08:19 AM, Nicolas Paris wrote:
> > Hi
> >
> > I d'like my user be able to select on any new table from other users.
> >
> Would ROLE Groups solve your problem?
Maybe yes, not sure what it is. I tested this:
> create role myro
If somebody is interested in connection to various JDBC-compatible
databases through postgres_fdw,
please look at my pq2jdbc project: https://github.com/postgrespro/pq2jdbc
Details of the project are in README file.
If somebody can find some other use cases for libpq to JDBC adapter,
please let
Nicolas Paris wrote:
> I d'like my user be able to select on any new table from other users.
>
> > ALTER DEFAULT PRIVILEGES FOR ROLE "theowner1" IN SCHEMA "myschema" GRANT
> > select ON TABLES TO "myuser"
> > ALTER DEFAULT PRIVILEGES FOR ROLE "theowner2" IN SCHEMA "myschema" GRANT
> > se
On Wed, Nov 14, 2018 at 09:04:44PM +0100, Laurenz Albe wrote:
> Nicolas Paris wrote:
> > I d'like my user be able to select on any new table from other users.
> >
> > > ALTER DEFAULT PRIVILEGES FOR ROLE "theowner1" IN SCHEMA "myschema"
> > > GRANT select ON TABLES TO "myuser"
> > > ALTER DEFA
Maybe I'm missing something, but doesn't this solve your problem
as stated?
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO public;
regards, tom lane
Jean-Marc Lessard writes:
> Would you recommend bytea over LOB considering that the max LOB size is well
> bellow 1GB?
Yes, probably. The reason that pg_dump has trouble with lots of small
BLOBs is the 9.0-era decision to treat BLOBs as independent objects
having their own owners, privilege att
On 11/14/2018 11:14 AM, Jean-Marc Lessard wrote:
Adrien Nayrat wrote:
> With 17 million LO, it could eat lot of memory ;)
Yes it does.
I did several tests and here are my observations.
First memory settings are:
shared_buffers = 3GB
work_mem = 32Mb
maintenance_work_mem = 1GB
effective_cache_siz
On Wed, Nov 14, 2018 at 03:53:39PM -0500, Tom Lane wrote:
> Maybe I'm missing something, but doesn't this solve your problem
> as stated?
>
> ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO public;
Not sure that's equivalent to what I am looking for below (but is not allowe
On 11/14/18 10:24 AM, dcl...@cinci.rr.com wrote:
Please reply to list also.
Ccing list.
Adrian Klaver wrote:
On 11/14/18 9:25 AM, dcl...@cinci.rr.com wrote:
Hello;
I've written a Java program which uses Postgresql via JDBC. The program works
fine on all RedHat systems I've tested exce
Adrian Klaver wrote:
> On 11/14/18 10:24 AM, dcl...@cinci.rr.com wrote:
> Please reply to list also.
> Ccing list.
> >
> > Adrian Klaver wrote:
> >> On 11/14/18 9:25 AM, dcl...@cinci.rr.com wrote:
> >>> Hello;
> >>>
> >>> I've written a Java program which uses Postgresql via JDBC.
On 11/14/18 5:03 PM, dcl...@cinci.rr.com wrote:
Adrian Klaver wrote:
On 11/14/18 10:24 AM, dcl...@cinci.rr.com wrote:
Please reply to list also.
Ccing list.
Adrian Klaver wrote:
On 11/14/18 9:25 AM, dcl...@cinci.rr.com wrote:
Hello;
I've written a Java program which uses Postgr
Looks very interesting,
Cheers,
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Wed, 14 Nov 2018 at 14:57, Konstantin Knizhnik
wrote:
> If somebody is interested in connection to various JDBC-compatible
> databases through postgres_fdw,
> please look at my pq2jdbc project: https:/
On Wed, Nov 14, 2018 at 7:08 PM Adrian Klaver
wrote:
> On 11/13/18 11:04 PM, Sachin Kotwal wrote:
> > Hi PostgreSQL lovers,
> >
> > I heard news that Redhat is going to acquired by IBM. IBM has its on
> > database. And they have history of selling applications with their own
> > hardware (softwar
Hi Team,
We would like to migrate our Postgresql VM instance on Google Cloud
Platform to Google Cloud SQL with a minimal downtime. As I checked, we have
to export and import the SQL file and our database size is large and cannot
afford longer downtime.
Do any have solution to achieve this?.
Than
31 matches
Mail list logo