[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

[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

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. --

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 >

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

[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:

[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

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

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

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

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

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

[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

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

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) >

[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

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

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 >

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 > >:

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 > >: > > On 11/8/2016 2:34 PM, Hector Yuen wrote: > > I am confused on which are the parameters for different queries. I am

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

[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

[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

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

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

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

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

[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

[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