[GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

Hello, I have two databases SQLlite and Postgres, SQLite is my local database in it I am saving fingerprint templates that get capture onsite (i.e offline) and my column is of type BLOB. Now I want to sync these templates into Postgres (to the server), so I created a column of type bytea but Post

[GENERAL] How the Planner in PGStrom differs from PostgreSQL?

I am reading through Postgres and PGStrom. Regarding the planning factors, I need some clarifications. Can u help me with that? Planner in Postgres checks for different scan and join methods, and then find the cheapest one and creates a query plan tree. While going for same thing in GPU, the check

Re: [GENERAL] Postgresql error (and service disruption) on Windows

On Thu, Nov 10, 2016 at 3:10 AM, nore...@evolu-s.it wrote: > Someone else facing this problem? Saw that a couple of times. Anti-virus softwares on Windows are known to interact badly with Postgres instances if no filters are applied or if they are kept around running. -- Michael -- Sent via p

Re: [GENERAL] which work memory parameter is used for what?

On Tue, Nov 8, 2016 at 1:53 PM, Hector Yuen wrote: > Hello, > > I am confused on which are the parameters for different queries. I am > trying to run VACUUM on a big table, and it is easier for me to set the > work memory for the specific session instead of tuning it in > postgresql.conf. > > I n

Re: [GENERAL] Linux equivalent library for "postgres.lib" from Windows

We are depending on postgres.lib while creating a postgre extension for windows. We need to know the equivalent library in Linux to build the same in Linux to get the symbols resolve correctly. Any help is appreciated. -Kiran G -Original Message- From: Michael Paquier [mailto:micha

[GENERAL] which work memory parameter is used for what?

Hello, I am confused on which are the parameters for different queries. I am trying to run VACUUM on a big table, and it is easier for me to set the work memory for the specific session instead of tuning it in postgresql.conf. I noticed that if I do: set work_mem='1GB'; it doesn't help VACUUM,

Re: [GENERAL] ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints

Hello, thanks for reply, I investigated this and thanks to pg_xlog_dump i found: /usr/pgsql-9.5/bin/pg_xlogdump 00010870007C 00010870007D | head -1 rmgr: Heaplen (rec/tot): 7/53, tx: 284003096, lsn: 870/7C30, prev 870/7BD0, desc: LOCK off 2: xid

[GENERAL] Postgresql error (and service disruption) on Windows

Hi again, our support team is reporting cases where postgres connections are suddenly dropped, but reconnecting again soon everyting is OK. Environment is PostgreSQL 9.1 on Windows (various versions) Asfer some research, I found on postgresql log many of these messages could not reserve shar

Re: [GENERAL] Role and grants

On 11/09/2016 02:46 PM, Fran ... wrote: Thanks for your reply. I had seen that link from documentation but I do not understand why it prints just "connect,temporary and create": CTc/test1 I think it should be print "arwdDxt". It is explained in the documentation at the link (https://www.po

Re: [GENERAL] Role and grants

On 11/9/2016 2:46 PM, Fran ... wrote: I had seen that link from documentation but I do not understand why it prints just "connect,temporary and create": CTc/test1 I think it should be print "arwdDxt". Connect, Temporary and Create are the only permissions a DATABASE has. a SCHEMA has Cre

Re: [GENERAL] Role and grants

Thanks for your reply. I had seen that link from documentation but I do not understand why it prints just "connect,temporary and create": CTc/test1 I think it should be print "arwdDxt". With this other command neither I get more information: postgres=# \du List o

Re: [GENERAL] Role and grants

On 11/09/2016 11:05 AM, Fran ... wrote: Hi, I am a new user with PostgreSQL, I came from MySQL and I am experiencing some issues with roles and privileges. I have created a DB,user and grant privilege on this DB to this user. How could I check what is the privileges/permissions for this user?

Re: [GENERAL] Role and grants

On Wed, Nov 9, 2016 at 2:05 PM, Fran ... wrote: > Hi, > > > I am a new user with PostgreSQL, I came from MySQL and I am experiencing > some issues with roles and privileges. > > > I have created a DB,user and grant privilege on this DB to this user. How > could I check what is the privileges/perm

[GENERAL] Role and grants

Hi, I am a new user with PostgreSQL, I came from MySQL and I am experiencing some issues with roles and privileges. I have created a DB,user and grant privilege on this DB to this user. How could I check what is the privileges/permissions for this user? Transcript: postgres=# create datab

Re: [GENERAL] Postgresql errors on Windows with F-Secure AntiVirus

On Wed, Nov 9, 2016 at 11:56 AM, Scott Marlowe wrote: > On Wed, Nov 9, 2016 at 11:29 AM, Moreno Andreo > wrote: >> Hi again, >> our support team is reporting cases where postgres connections are >> suddenly dropped, but reconnecting again soon everyting is OK. >> Environment is PostgreSQL 9.

Re: [GENERAL] Postgresql errors on Windows with F-Secure AntiVirus

On Wed, Nov 9, 2016 at 11:29 AM, Moreno Andreo wrote: > Hi again, > our support team is reporting cases where postgres connections are > suddenly dropped, but reconnecting again soon everyting is OK. > Environment is PostgreSQL 9.1 on Windows (various versions) > Asfer some research, I found o

[GENERAL] Postgresql errors on Windows with F-Secure AntiVirus

Hi again, our support team is reporting cases where postgres connections are suddenly dropped, but reconnecting again soon everyting is OK. Environment is PostgreSQL 9.1 on Windows (various versions) Asfer some research, I found on postgresql log many of these messages could not reserve shar

Re: [GENERAL] which work memory parameter is used for what?

On Wed, Nov 9, 2016 at 10:05 AM, Andreas Joseph Krogh wrote: > På onsdag 09. november 2016 kl. 15:54:13, skrev Adrian Klaver < > adrian.kla...@aklaver.com>: > > On 11/08/2016 06:45 PM, Andreas Joseph Krogh wrote: > > På onsdag 09. november 2016 kl. 03:02:54, skrev John R Pierce > > mailto:pie...@

Re: [GENERAL] which work memory parameter is used for what?

On Wed, Nov 9, 2016 at 7:54 AM, Adrian Klaver wrote: > On 11/08/2016 06:45 PM, Andreas Joseph Krogh wrote: > > På onsdag 09. november 2016 kl. 03:02:54, skrev John R Pierce > > > > > > https://www.postgresql.org/docs/current/static/runtime- > config-resource.html > > > > > > maintenance_w

Re: [GENERAL] which work memory parameter is used for what?

På onsdag 09. november 2016 kl. 15:54:13, skrev Adrian Klaver < adrian.kla...@aklaver.com >: On 11/08/2016 06:45 PM, Andreas Joseph Krogh wrote: > På onsdag 09. november 2016 kl. 03:02:54, skrev John R Pierce > mailto:pie...@hogranch.com>>: > >     On 11/8/2016

Re: [GENERAL] which work memory parameter is used for what?

On 11/08/2016 06:45 PM, Andreas Joseph Krogh wrote: > På onsdag 09. november 2016 kl. 03:02:54, skrev John R Pierce > mailto:pie...@hogranch.com>>: > > On 11/8/2016 2:34 PM, Hector Yuen wrote: > > I am confused on which are the parameters for different queries. I am > > trying to run V

Re: [GENERAL] ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints

Michael Paquier writes: > On Wed, Nov 2, 2016 at 12:09 AM, wrote: >> we tried new feature RLS - tested on postgres 9.5.3 / CentOS6. When we turn >> on ENABLE RLS + FORCE RLS on normal workload cause huge produce checkpoints >> (about 30x or more), our disk partition for xlog was full and log shi

[GENERAL] Re: [GENERAL] FTS query, statistics and planner estimations…

On Wed, Nov 9, 2016 at 11:19 AM, Pierre Ducroquet wrote: > Indeed the words in the query are correlated, but I do hope that the FTS > indexing is able to cope with that. If the query returns correct results in reasonable time it can. OTOH the planner, and the statistics system, is another beast.

[GENERAL] Re: [GENERAL] FTS query, statistics and planner estimations…

2016-11-09 11:19 GMT+01:00 Pierre Ducroquet : > On Wednesday, November 9, 2016 10:40:10 AM CET Francisco Olarte wrote: > > Pierre: > > > > On Wed, Nov 9, 2016 at 10:22 AM, Pierre Ducroquet > > > > wrote: > > > The query does a few joins «after» running a FTS query on a main table. > > > The FTS q

Re: [GENERAL] FTS query, statistics and planner estimations…

On Wednesday, November 9, 2016 10:40:10 AM CET Francisco Olarte wrote: > Pierre: > > On Wed, Nov 9, 2016 at 10:22 AM, Pierre Ducroquet > > wrote: > > The query does a few joins «after» running a FTS query on a main table. > > The FTS query returns a few thousand rows, but the estimations are wro

Re: [GENERAL] Re: [GENERAL] FTS query, statistics and planner estimations…

On Wednesday, November 9, 2016 10:51:11 AM CET Pavel Stehule wrote: > 2016-11-09 10:40 GMT+01:00 Francisco Olarte : > > Pierre: > > > > On Wed, Nov 9, 2016 at 10:22 AM, Pierre Ducroquet > > > > wrote: > > > The query does a few joins «after» running a FTS query on a main table. > > > The FTS que

Re: [GENERAL] FTS query, statistics and planner estimations…

On Wednesday, November 9, 2016 1:01:29 PM CET you wrote: > Hello, > > On 09.11.2016 12:22, Pierre Ducroquet wrote: > > Hello > > > > I recently stumbled on a slow query in my database that showed an odd > > behaviour related to the statistics of FTS queries. > > The query does a few joins «after»

Re: [GENERAL] FTS query, statistics and planner estimations…

Hello, On 09.11.2016 12:22, Pierre Ducroquet wrote: Hello I recently stumbled on a slow query in my database that showed an odd behaviour related to the statistics of FTS queries. The query does a few joins «after» running a FTS query on a main table. The FTS query returns a few thousand rows,

[GENERAL] Re: [GENERAL] Re: [GENERAL] FTS query, statistics and planner estimations…

2016-11-09 10:40 GMT+01:00 Francisco Olarte : > Pierre: > > On Wed, Nov 9, 2016 at 10:22 AM, Pierre Ducroquet > wrote: > > The query does a few joins «after» running a FTS query on a main table. > > The FTS query returns a few thousand rows, but the estimations are wrong, > > leading the optimize

[GENERAL] Re: [GENERAL] FTS query, statistics and planner estimations…

Pierre: On Wed, Nov 9, 2016 at 10:22 AM, Pierre Ducroquet wrote: > The query does a few joins «after» running a FTS query on a main table. > The FTS query returns a few thousand rows, but the estimations are wrong, > leading the optimizer to terrible plans compared to what should happen, and > th

[GENERAL] FTS query, statistics and planner estimations…

Hello I recently stumbled on a slow query in my database that showed an odd behaviour related to the statistics of FTS queries. The query does a few joins «after» running a FTS query on a main table. The FTS query returns a few thousand rows, but the estimations are wrong, leading the optimizer