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,
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 г., в
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
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.
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:
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
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
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
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
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?.
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
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
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
$
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
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
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
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)
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"
>
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
> >
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
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
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
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
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
25 matches
Mail list logo
