[GENERAL] Using constraint exclusion with 2 floats

Hi everyone, Is there an easy way (that I maybe missed) to use constraint exclusion with 2 floats ? Must I find an extension the temporal extension which create a new type with 2 timestamp or can I usethe operator with 2 fields ? Thank you

Re: [GENERAL] Using constraint exclusion with 2 floats

On Wed, Oct 12, 2011 at 11:23 PM, Simon Riggs si...@2ndquadrant.com wrote: On Wed, Oct 12, 2011 at 10:16 AM, Julien Rouhaud rjuju...@gmail.com wrote: Hi everyone, Is there an easy way (that I maybe missed) to use constraint exclusion with 2 floats ? Must I find an extension the temporal

Re: [GENERAL] Are file system level differential/incremental backups possible?

As there's one file for each object, a single update on each would make you to copy the all the file again. I heard there was tool to make differentiel copy of a part of a file but I don't know if it's really efficient. Anyway, a better way for you would be to do a regular backup (with

Re: [GENERAL] Are file system level differential/incremental backups possible?

On Thu, Oct 13, 2011 at 12:04 AM, Bob Hatfield bobhatfi...@gmail.comwrote: Anyway, a better way for you would be to do a regular backup (with pg_start_backup, copy and pg_stop_backup) and then use wal archive_command to keep the xlogs between 2 full backups. Thanks Julien. Can

Re: [GENERAL] Postgres Account Inherit Question

On Fri, Oct 14, 2011 at 6:38 PM, Carlos Mennens carlos.menn...@gmail.comwrote: I've configured my 'pg_hba.conf' file to look as follows: # local is for Unix domain socket connections only local all all md5 # IPv4 local connections: hostall

Re: [GENERAL] Confused About pg_* Tables

On Fri, Oct 14, 2011 at 6:06 PM, Carlos Mennens carlos.menn...@gmail.comwrote: I'm confused about how I'm able to access the following pg_* tables regardless of connected database. I thought these tables were hidden or stored in the 'postgres' database but I'm still able to access this data

Re: [GENERAL] Confused About pg_* Tables

On Fri, Oct 14, 2011 at 6:57 PM, Julien Rouhaud rjuju...@gmail.com wrote: On Fri, Oct 14, 2011 at 6:06 PM, Carlos Mennens carlos.menn...@gmail.comwrote: I'm confused about how I'm able to access the following pg_* tables regardless of connected database. I thought these tables were hidden

Re: [GENERAL] [ADMIN] pg_dump : no tables were found.

On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka lenka.piy...@gmail.com wrote: Hi, I m trying to take backup of data of a particular table using pg_dump. I used double quotes for table name but output is : pg_dump : no tables were found. Command used : -h localhost -p 5432 -U postgres -W -F p

Re: [GENERAL] pg_database_size differs from df -s

On Wed, Jun 6, 2012 at 6:28 PM, Tom Lane t...@sss.pgh.pa.us wrote: Frank Lanitz fr...@frank.uvena.de writes: Am 06.06.2012 17:49, schrieb Tom Lane: For me, pg_database_size gives numbers that match up fairly well with what du says. I would not expect an exact match, since du probably

Re: [GENERAL] POWA tool

/powa/blob/master/README.md). Regards. -- Julien Rouhaud http://www.dalibo.com

Re: [GENERAL] Is there any way to measure disk activity for each query?

to get actual disk reads and writes for all normalized queries. Regards. Cheers, Jeff -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] Why does the range type's upper function behave inconsistently?

types, the canonical form is used, which is [). Check http://www.postgresql.org/docs/current/static/rangetypes.html and the discrete range types paragraph. Regards. Regards, Dane - -- Julien Rouhaud http://dalibo.com - http://dalibo.org -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.17

Re: [GENERAL] Creating table with data from a join

by design? Could you please suggest other alternatives to try (if there are any)? And what might be the reason that 3 is not outperforming the other 2? Thank you, Igor -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Creating table with data from a join

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/07/2015 18:21, Igor Stassiy wrote: Julien, I have the following setting for WAL level: #wal_level = minimal (which defaults to minimal anyway) On Tue, Jul 14, 2015 at 6:19 PM Julien Rouhaud julien.rouh...@dalibo.com mailto:julien.rouh

Re: [GENERAL] Creating table with data from a join

more. If you don't care about losing data on this table if your server crashes, you can try option #3 with an unlogged table. On Tue, Jul 14, 2015 at 6:19 PM Julien Rouhaud julien.rouh...@dalibo.com mailto:julien.rouh...@dalibo.com wrote: On 14/07/2015 11:12, Igor Stassiy wrote

Re: [GENERAL] Creating table with data from a join

/sql-createtable.html and the UNLOGGED part to check if an unlogged table is suitable for you. On Tue, Jul 14, 2015 at 6:37 PM Julien Rouhaud julien.rouh...@dalibo.com mailto:julien.rouh...@dalibo.com wrote: On 14/07/2015 18:21, Igor Stassiy wrote: Julien, I have the following

Re: [GENERAL] Oracle to PostgreSQL Migration - Need Information

), with a call like ora2pg -c ora2pg.conf -t SHOW_REPORT --dump_as_html --estimate_cost You can check a sample report here: http://ora2pg.darold.net/report.html - -- Julien Rouhaud http://dalibo.com - http://dalibo.org -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.17 (GNU/Linux

Re: [GENERAL] Why are no NEGATORS defined in the standard operators

rcode, o1.oprnegate, o2.oprname as negate from pg_operator o1 join pg_operator o2 on o1.oprnegate = o2.oid where o1.oprname = '=' and o1.oprleft = 'int8'::regtype and o1.oprright = 'int8'::regtype; oprname │ oprcode │ oprnegate │ negate ═╪═╪═══╪ = │ int8eq

Re: [GENERAL] plugin dev, oid to pointer map

y-value storage solution in the pg code? > if so, please point me to the right part of the source. > Yes, there's an hashtable implementation, see dynahash.c If you want to use that in shared memory in your extension, you can look at the pg_stat_statements extension (look for pgss_hash) for an

Re: [GENERAL] Confused by the behavior of pg_basebackup with replication slot

On 19/03/2016 15:58, Julien Rouhaud wrote: > Hello, > > On 19/03/2016 15:41, Yi, Yi wrote: >> Hello, >> >> I had an issue with the behavior of pg_basebackup command. I was convinced >> previously that pg_basebackup command always made the binary copy

Re: [GENERAL] RLS on catalog tables would be helpful

sts.postgresql.org/mj/mj_wwwusr?list=pgsql-hackers=on=archive-get-part=201602/753 once you log in you'll find the "Mail this message to..." link at bottom of the page. > However, if you view the raw message (there is a link for that on the > archives), save it locally, and then

Re: [GENERAL] bloated postgres data folder, clean up

. > > > > This message and any attachments have been scanned for viruses prior > leaving PAY.ON; however, PAY.ON does not guarantee the security of > this message and will not be responsible for any damages arising as > a result of any virus

Re: [GENERAL] index question

d also probably indexes used to cluster tables (indisclustered). You should also check since when the idsx_scan and other counters are aggregating before dropping any index. Check pg_stat_get_db_stat_reset_time(oid), with the oid of the related database(s). > > > Cheers

Re: [GENERAL] ShmemAlloc maximum size

s.c how it's done (_PG_INIT() and pgss_shmem_startup()). Asking a small amount probably works because some shared memory is requested but not totally used as soon as the server starts. Regards. -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] Query generator

https://github.com/anse1/sqlsmith), which works very well. -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Query generator

On 29/09/2016 23:23, Vinicius Segalin wrote: > 2016-09-29 16:32 GMT-03:00 Julien Rouhaud <julien.rouh...@dalibo.com > <mailto:julien.rouh...@dalibo.com>>: > You should try sqlsmith (https://github.com/anse1/sqlsmith > <https://github.com/anse1/sqlsmith>

Re: [GENERAL] Why is this query not using GIN index?

;> (actual time=0.110..75.546 rows=10 loops=1) >>> Filter: (to_tsvector('english'::regconfig, (title)::text) @@ >>> '''abc'' | ''def'''::tsquery) >>> Rows Removed by Filter: 10221 >>> Planning time: 0.176 ms >>> Execution time: 75.564 ms >>> (6 rows) >>> >>> Any ideas? >>> -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] forcing a table (parent in inheritance) tor emain empty

aints > * Primary Keys > * Foreign keys > * Rules and Triggers > you can specify a "NO INHERIT" on the check constraint, that should solve your issue. -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] How to config start/stop scripts in a different data dir for CentOS7/systemctl/PG9.6

devrim/index.php?/archives/82-Running-more-than-one-9.4-9.3-instance-in-parallel-on-RHEL-7.html (This link is available in the "Yum Howto" section of yum.postgresql.org) Last time I tried it worked as intended. -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql

Re: [GENERAL] ora2pg - Java Message Service (JMS) Type

ugfix is not enough or if you find other issues, could you report them directly on github (https://github.com/darold/ora2pg/issues)? Thanks! -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ora2pg - Java Message Service (JMS) Type

On Mon, Dec 12, 2016 at 04:15:59PM +, Joanna Xu wrote: > On Fri, Dec 11, 2016 12:43 PM, Julien Rouhaud wrote: > >>I forwarded your mail to the author, since he's not on this mailing-list. > >>This issue should be fixed with commit > >>>>htt

Re: [GENERAL] No select privileges when not connecting from login postgres

om > doom=# select 'world' as hello; > select 'world' as hello; > hello >--- > world >(1 row) > [...] > I'm running out of ideas for things to check. Any suggestions? > Any unusual errors in the logs? Or maybe a "\o /somefile" in

Re: [GENERAL] Migrating data from DB2 zOS to PostgreSQL

https://github.com/dalibo/db2topg The README should provide all needed informations. -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] too may LWLocks

uld also try on a postgres build having LWLOCK_STATS defined. -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_stat_statements -- Historical Query

On Thu, Aug 10, 2017 at 6:41 AM, Michael Paquier wrote: > On Thu, Aug 10, 2017 at 6:23 AM, anand086 wrote: >> I was looking for a way to maintain historical query details in Postgres to >> answer questions like >> >> What was the sql call rate

Re: [GENERAL] pg_stat_statements -- Historical Query

On Thu, Aug 10, 2017 at 3:00 PM, Melvin Davidson wrote: > > If you are interested in historical stats, you would probably fair a lot > better with PgBadger. It is free > and highly customizable. In addition to SQL call rates at different times, > it provides analysis of >

Re: [GENERAL] Difficult while acquiring LWLocks

On 03/05/2017 15:01, hariprasath nallasamy wrote: > > AFAIK yes this is the correct way to use multiple lwlocks. > > > Thanks.! > > Just curious, Is there any other way to do this.? Probably no, except asking for 10 different tranches :) -- Julien Rouhaud htt

Re: [GENERAL] Difficult while acquiring LWLocks

quot; LWLockPadded *lwLockPadded = GetNamedLWLockTranche("Some_10_LWLocks"); >LWLock *lock = &(lwLockPadded[index in 0 to 9]).lock; "* > > Is the above code snippet a valid for requesting some 10 LWLocks? > > AFAIK yes this is the correct way to use multiple lwlocks.

Re: [GENERAL] Ora2Pg-Database migration report

ou want more details, you can either look at the code or open an issue on the repo (https://github.com/darold/ora2pg/). -- Julien Rouhaud http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po