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

On Thu, Nov 17, 2016 at 7:09 PM, Mark Anns wrote: > Can u explain this statement "check whether the scan qualifier can > be executable on GPU device" > > What are the scan qualifiers? > > How to determine whether they are device executable or not? > > The cost estimates

Re: [GENERAL] [HACKERS] Change in order of criteria - reg

On 2016/06/01 13:07, sri harsha wrote: > Hi, > > In PostgreSQL , does the order in which the criteria is given matter ?? > For example > > Query 1 : Select * from TABLE where a > 5 and b < 10; > > Query 2 : Select * from TABLE where b <10 and a > 5; > > Are query 1 and query 2 the same in

Re: [GENERAL] pg_restore casts check constraints differently

On Wed, Mar 30, 2016 at 6:45 AM, Tom Lane wrote: > Joshua Ma writes: >> This might not be a common case, but we're using pg_dump in a testing >> environment to check migrations - 1) we initialize the db from HEAD, >> pg_dump it, 2) we initialize the db

Re: [GENERAL] Exclusively locking parent tables while disinheriting children.

On Wed, Sep 16, 2015 at 12:10 AM, Thom Brown wrote: > On 7 August 2015 at 12:34, Thom Brown wrote: >> On 30 July 2015 at 13:35, Rowan Collins wrote: >>> So what I want to understand is what the risk of adding this lock are - >>> under

Re: [GENERAL] Where should I post 3rd party product announcements?

On Tue, Oct 14, 2014 at 4:58 PM, Jonathan Neve jonat...@copycat.fr wrote: Hello, I am the author of a database replication solution to which I recently added Postgres support. I would like to let the PG community know about it and I therefore posted a message to this list, but it didn't come

Re: [GENERAL] Is it possible to create an index without keeping the indexed data in a column?

On Fri, Aug 1, 2014 at 2:50 PM, Amit Langote amitlangot...@gmail.com wrote: Not sure exactly if it applies here; Re-reading the OP again, perhaps it doesn't. Sorry about the noise -- Amit -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Is it possible to create an index without keeping the indexed data in a column?

On Fri, Aug 1, 2014 at 10:48 AM, Michael Paquier michael.paqu...@gmail.com wrote: On Fri, Aug 1, 2014 at 4:47 AM, Larry White ljw1...@gmail.com wrote: Is there a way to get Postgres to index the table as if the JSON were there, but not actually put the data in the table? I could either store

Re: [GENERAL] Request for Unsubscribe

On Thursday, April 24, 2014, Bhim Kumar bhimkuma...@gmail.com wrote: Hi sir, I am getting a lot of mails which are tough to handle. Please unsubscribe my mail id, so that I would not get unwanted mail. Use the subscribe/unsubscribe form here.

Re: [GENERAL] About upgrading a (tuple?) lock in a rollback'd sub-transaction

On Thu, Apr 10, 2014 at 10:25 PM, Rob Sargent robjsarg...@gmail.com wrote: And it also tells you how to stop it --bibtex iirc Yeah, it's a caution against a potentially harmful usage anyway. Users should not use it at all. I was just wondering if the description of the behavior, that is,

Re: [DOCS] [GENERAL] About upgrading a (tuple?) lock in a rollback'd sub-transaction

On Fri, Apr 11, 2014 at 11:52 AM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Amit Langote wrote: On Thu, Apr 10, 2014 at 10:25 PM, Rob Sargent robjsarg...@gmail.com wrote: And it also tells you how to stop it --bibtex iirc Yeah, it's a caution against a potentially harmful usage anyway

[GENERAL] About upgrading a (tuple?) lock in a rollback'd sub-transaction

Hi, Currently there is a warning against the following in manual: BEGIN; SELECT * FROM mytable WHERE key = 1 FOR UPDATE; SAVEPOINT s; UPDATE mytable SET ... WHERE key = 1; ROLLBACK TO s; here: http://www.postgresql.org/docs/9.2/static/sql-select.html IIUC, it says if the lock-upgrading

[GENERAL] Table Rewrite During ALTER TABLE ... ADD COLUMN ... DEFAULT NULL

Hi, When I do the following: ALTER TABLE table ADD COLUMN numeric(x) DEFAULT NULL; The table is rewritten whereas notes section on the manual page for ALTER TABLE says otherwise (which holds true for most of the cases though). http://www.postgresql.org/docs/devel/static/sql-altertable.html As

Re: [GENERAL] Table Rewrite During ALTER TABLE ... ADD COLUMN ... DEFAULT NULL

On Thu, Apr 3, 2014 at 12:54 PM, Tom Lane t...@sss.pgh.pa.us wrote: Amit Langote amitlangot...@gmail.com writes: When I do the following: ALTER TABLE table ADD COLUMN numeric(x) DEFAULT NULL; The table is rewritten whereas notes section on the manual page for ALTER TABLE says otherwise

Re: [GENERAL] Table Rewrite During ALTER TABLE ... ADD COLUMN ... DEFAULT NULL

On Thu, Apr 3, 2014 at 1:19 PM, Tom Lane t...@sss.pgh.pa.us wrote: Amit Langote amitlangot...@gmail.com writes: On Thu, Apr 3, 2014 at 12:54 PM, Tom Lane t...@sss.pgh.pa.us wrote: Some experimentation suggests that we are smart about DEFAULT NULL unless the column type requires a length

Re: [GENERAL] Table Rewrite During ALTER TABLE ... ADD COLUMN ... DEFAULT NULL

On Thu, Apr 3, 2014 at 1:19 PM, Tom Lane t...@sss.pgh.pa.us wrote: Amit Langote amitlangot...@gmail.com writes: On Thu, Apr 3, 2014 at 12:54 PM, Tom Lane t...@sss.pgh.pa.us wrote: Some experimentation suggests that we are smart about DEFAULT NULL unless the column type requires a length

Re: [NOVICE][GENERAL] Convert Datum to an user-defined data type?

On Mon, Mar 10, 2014 at 11:09 PM, Anh Pham atpham@gmail.com wrote: Hi everyone, I have created a new data types using SQL in a database: CREATE TYPE type1 AS ( score integer, time integer[], ); I also created a server extension module (C code), and I was able to retrieve a Datum

Re: [GENERAL] execute table query in backend

On Tue, Mar 4, 2014 at 12:38 AM, Anh Pham atpham@gmail.com wrote: Hi, I am trying to extend the server backend by writing a new module. Basically, it tries to retrieve tuples from a specific table using some predefined qualifications (equivalent to SELECT FROM WHERE client sql statement

Re: [GENERAL] how is text-equality handled in postgresql?

, * so we follow Perl's lead and sort equal strings according to * strcmp(). */ if (result == 0) result = strcmp(a1p, a2p); -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] how is text-equality handled in postgresql?

On Wed, Jan 15, 2014 at 9:02 PM, Ivan Voras ivo...@freebsd.org wrote: On 15/01/2014 12:36, Amit Langote wrote: On Wed, Jan 15, 2014 at 7:39 PM, Ivan Voras ivo...@freebsd.org wrote: On 15/01/2014 10:10, Gábor Farkas wrote: hi, when i create an unique-constraint on a varchar field, how exactly

Re: [GENERAL] pg_depend OBJID not found

On Wed, Jan 15, 2014 at 8:37 PM, saggarwal sanj.aggar...@gmail.com wrote: http://postgresql.1045698.n5.nabble.com/file/n5787214/ScreenShot.jpg hi Any help appreciated (newbie to pgsql) I have a function f_Sanjeev and create a view create view v_sanjeev as select * from f_sanjeev() the view

Re: [GENERAL] How are pg_operator and pg_type related with each other?

histogram.) -- Amit Langote -- 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] How to specify/mock the statistic data of tables in PostgreSQL

estimation is described here: http://www.postgresql.org/docs/9.3/static/row-estimation-examples.html However, to understand how they are generated by ANALYZE (in most cases, using random sampling), I guess you'd need to go through its code in the source file src/backend/commands/analyze.c. -- Amit

Re: [GENERAL] How to specify/mock the statistic data of tables in PostgreSQL

the join order (by setting join_collapse_limit and from_collapse_limit to 1) , is there any other factor that may affect the structure of execution plan regardless of the data access method. 2014-01-10 ygnhzeus 发件人：Amit Langote

Re: [GENERAL] Bugs revealed by static code analysis

On Wed, Dec 25, 2013 at 9:41 PM, Fernando Correia fernandoacorr...@gmail.com wrote: As a PostgreSQL user, I'd like to bring to the attention of the community and the developers that Andrey Karpov from PVS-Studio published an article listing several potential bugs in PostgreSQL. These bugs were

Re: [GENERAL] unexpected pageaddr error in db log

On Thu, Dec 19, 2013 at 12:25 PM, wd w...@wdicc.com wrote: hi, We have upgrade our database from PostgreSQL 9.2.4 to 9.3.2, use dump restore in a fresh db created by initdb. Then use pg_basebackup created 2 slave db, the error occur when start the database. db1 [2013-12-19

Re: [GENERAL] pg_trgm module: no convertion into Trigrams on one side when comparing

On Thu, Nov 14, 2013 at 9:05 PM, Janek Sendrowski jane...@web.de wrote: Hi Amit, Thanks for your answer. My issue is that I still need a ranking like the similarity when comparing trigrams. I'm working on a similarity search, which determindes similiar sentences from my table. The

Re: [GENERAL] pg_trgm module: no convertion into Trigrams on one side when comparing

On Thu, Nov 14, 2013 at 2:37 AM, Janek Sendrowski jane...@web.de wrote: Hi, I'm using the pg_trgm module, Is there a possibility not to convert one side of the string when comparing? I need a kind of reference string containing only certain trigrams. It's not possible to build every kind of

[GENERAL] GIN fast update technique and work_mem

Hi, While going through the documentation for GIN fast update technique, I read - ...or if the pending list becomes too large (larger than work_mem), the entries are moved to the main GIN data structure using the same bulk insert techniques used during initial index creation. The work_mem links

Re: [GENERAL] GIN fast update technique and work_mem

On Thu, Oct 24, 2013 at 7:26 PM, Andres Freund and...@2ndquadrant.com wrote: On 2013-10-24 18:40:46 +0900, Amit Langote wrote: While going through the documentation for GIN fast update technique, I read - ...or if the pending list becomes too large (larger than work_mem), the entries

[GENERAL] A client and server encoding question

an impression that above shouldn't have caused any problem? Should UTF8 handle the situation gracefully? Or am I missing something? -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] A client and server encoding question

On Tue, Oct 22, 2013 at 7:00 PM, Albe Laurenz laurenz.a...@wien.gv.at wrote: Amit Langote wrote: With a server initdb'd with UTF8 encoding , if I create a table with a client using LATIN1 encoding and later try to work with the relation with a client using UTF8 encoding (both the scenarios

[GENERAL] Links in docs broken

Hi, In 9.2 docs, the first link (i18ngurus) in the further reading section here: http://www.postgresql.org/docs/9.2/static/multibyte.html seems to be broken. Should it be updated/removed? (I see it's removed in 9.3 docs) -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Why there are no max_wal_receivers

On Tue, Oct 8, 2013 at 3:05 PM, 高健 luckyjack...@gmail.com wrote: Hello: Thank you all for kindly replying my question. I read the documentation about pg_basebackup. The description says: The server must also be configured with max_wal_senders set high enough to leave at least one

Re: [GENERAL] Why there are no max_wal_receivers

, there is only one WAL receiver on each standby server. -- Amit Langote -- 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] logging statements in PostgreSQL

://www.postgresql.org/docs/devel/static/auto-explain.html -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Bottlenecks with large number of relation segment files

pgbench -i -s 3500 would be. May the routines in fd.c become bottleneck with a large number of concurrent connections to above database, say something like pgbench -j 8 -c 128? Is there any other place I should be paying attention to? -- Amit Langote -- Sent via pgsql-general mailing list

Re: [GENERAL] Bottlenecks with large number of relation segment files

On Mon, Aug 5, 2013 at 5:01 PM, KONDO Mitsumasa kondo.mitsum...@lab.ntt.co.jp wrote: Hi Amit, (2013/08/05 15:23), Amit Langote wrote: May the routines in fd.c become bottleneck with a large number of concurrent connections to above database, say something like pgbench -j 8 -c 128

Re: [GENERAL] Snapshot backups

in the backup_label file.) While you are reading the code, you can read the comment above the function read_backup_label() in src/backend/access/transam/xlog.c -- Amit Langote

Re: [GENERAL] SQL for multimedia retrieval

and retrieve the indexed content using PostgreSQL. -- Amit Langote -- 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] [HACKERS] maintenance_work_mem and CREATE INDEX time

Hi Jeff, On Tue, Jul 30, 2013 at 3:25 AM, Jeff Janes jeff.ja...@gmail.com wrote: On Tue, Jul 23, 2013 at 10:56 PM, Amit Langote amitlangot...@gmail.com wrote: On Wed, Jul 24, 2013 at 3:20 AM, Jeff Janes jeff.ja...@gmail.com wrote: The heap structure used in external sorts is cache

Re: [GENERAL] async streaming and recovery_target_timeline=latest

;a=commit;h=424cc31a3785bd01108e6f4b20941c6442d3d2d0 -- Amit Langote -- 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] Fastest Index/Algorithm to find similar sentences

perform better where pg_trgm can not. -- Amit Langote -- 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] How to do incremental / differential backup every hour in Postgres 9.1?

folder or just the 16,384KB WAL files? Your archiving setup (that is archive_command) should take care of all that needs to be copied to the archive location. Have you read about pg_rman? Read about it at the following link: https://code.google.com/p/pg-rman/wiki/readme -- Amit Langote

Re: [GENERAL] maintenance_work_mem and CREATE INDEX time

On Tue, Jul 23, 2013 at 1:11 PM, Amit Langote amitlangot...@gmail.com wrote: Hello, While understanding the effect of maintenance_work_mem on time taken by CREATE INDEX, I observed that for the values of maintenance_work_mem less than the value for which an internal sort is performed

Re: [GENERAL] [HACKERS] maintenance_work_mem and CREATE INDEX time

On Wed, Jul 24, 2013 at 6:02 AM, Jeff Janes jeff.ja...@gmail.com wrote: On Tue, Jul 23, 2013 at 1:23 AM, Amit Langote amitlangot...@gmail.com wrote: On Tue, Jul 23, 2013 at 1:11 PM, Amit Langote amitlangot...@gmail.com wrote: Hello, While understanding the effect of maintenance_work_mem

Re: [GENERAL] [HACKERS] maintenance_work_mem and CREATE INDEX time

On Wed, Jul 24, 2013 at 11:30 AM, Amit Langote amitlangot...@gmail.com wrote: On Wed, Jul 24, 2013 at 6:02 AM, Jeff Janes jeff.ja...@gmail.com wrote: If you are using trace_sort to report that, it reports the switch as happening as soon as it runs out of memory. At point, all we have been

Re: [GENERAL] [HACKERS] maintenance_work_mem and CREATE INDEX time

On Wed, Jul 24, 2013 at 3:20 AM, Jeff Janes jeff.ja...@gmail.com wrote: On Mon, Jul 22, 2013 at 9:11 PM, Amit Langote amitlangot...@gmail.com wrote: Hello, While understanding the effect of maintenance_work_mem on time taken by CREATE INDEX, I observed that for the values

[GENERAL] maintenance_work_mem and CREATE INDEX time

anyway. Does that make sense? -- Amit Langote -- 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] How can you get WAL segment has already been removed when doing synchronous replication ?!

to be archived/shipped is recycled? I remember something of that sort. Check this discussion: http://www.postgresql.org/message-id/51779b3b.1020...@lab.ntt.co.jp Is this logged on the master or a standby? -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Full text search

used? That would be helpful. -- Amit Langote -- 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] Archiving and recovering pg_stat_tmp

did you see when you did in past? I am not aware of such errors; am I missing some? -- Amit Langote -- 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] Archiving and recovering pg_stat_tmp

) would be the only way to preserve such historic (snapshots-like) information about those statistics. Server itself doesn't have any mechanism to preserve any historical information like those stats, am I right in saying that? -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Archiving and recovering pg_stat_tmp

are not WAL logged (like changes to table data) since they are managed using temporary files in pg_stat_temp and hence may not be recoverable using WAL replay to a particular state using PITR. but I may be wrong. Thoughts? -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] File System backup

it? Is that after OS restarts?) Did you, by any chance, use restart whereas you should have used start assuming you are using pg_ctl for the same? Issuing restart requires that you should already have server running (and that means postmaster.pid should be there in data directory). -- Amit Langote

Re: [GENERAL] Migration from DB2 to PostgreSQL

implement above function for conversion? Sachin, check if this link is related: http://stackoverflow.com/a/10139455/683402 + Here (from official PG docs): http://www.postgresql.org/docs/9.2/static/largeobjects.html -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Archiving and recovering pg_stat_tmp

When I checked on my 9.4dev installation, I found $PGDATA/pg_stat and there were per database .stat files. -- Amit Langote -- 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] Archiving and recovering pg_stat_tmp

persists across server restarts, which, might even be applicable to a PITR, as far as I can understand. This would need some testing, though, to be sure that it is the case. -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Archiving and recovering pg_stat_tmp

On Thu, Jun 20, 2013 at 8:32 PM, Amit Langote amitlangot...@gmail.com wrote: On Thu, Jun 20, 2013 at 6:05 PM, Sameer Thakur samthaku...@gmail.com wrote: Documentation mentions following: Thanks, but how does this relate to statistics recovery wrt PITR? Upon clean server shutdown, you have

Re: [GENERAL] Migration from DB2 to PostgreSQL

large? For example, if this function appears in a WHERE clause against a table containing millions of rows. -- Amit Langote -- 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] Migration from DB2 to PostgreSQL

Hi, On Thu, Jun 20, 2013 at 10:27 AM, Chris Angelico ros...@gmail.com wrote: On Thu, Jun 20, 2013 at 11:10 AM, Amit Langote amitlangot...@gmail.com wrote: If this particular function is to be used repeatedly in a single query, would the cost of having a wrapper function around the original

Re: [GENERAL] Migration from DB2 to PostgreSQL

On Thu, Jun 20, 2013 at 10:54 AM, Chris Angelico ros...@gmail.com wrote: On Thu, Jun 20, 2013 at 11:35 AM, Amit Langote amitlangot...@gmail.com wrote: On Thu, Jun 20, 2013 at 10:27 AM, Chris Angelico ros...@gmail.com wrote: If your wrapper function is written in SQL and is trivial (eg ignore

Re: [GENERAL] Migration from DB2 to PostgreSQL

On Thu, Jun 20, 2013 at 11:10 AM, Chris Angelico ros...@gmail.com wrote: On Thu, Jun 20, 2013 at 12:09 PM, Amit Langote amitlangot...@gmail.com wrote: Umm, my bad! I almost forgot I could write pure SQL function bodies. Although, why does following happen? (sorry, a 8.4.2 installation

Re: [GENERAL] More buffers used than a relation's relpages

On Tue, Jun 4, 2013 at 10:04 PM, Andres Freund and...@2ndquadrant.com wrote: On 2013-06-04 11:29:44 +0900, Amit Langote wrote: In what cases can a relation use more buffers (in shared memory) than its pg_class.relpages? relpages is primarily updated by (auto-)vacuum, (auto-)analyze, so

[GENERAL] More buffers used than a relation's relpages

|3548 | 3547 abc_2_idx|3209 | 3209 ... ... -- Amit Langote -- 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] More buffers used than a relation's relpages

On Tue, Jun 4, 2013 at 12:17 PM, Jeff Janes jeff.ja...@gmail.com wrote: On Monday, June 3, 2013, Amit Langote wrote: Hello, In what cases can a relation use more buffers (in shared memory) than its pg_class.relpages? I think relpages only counts pages in the main fork, while the buffer

Re: [GENERAL] How to check if Postgresql files are OK

frequent, tested, backups. How does one validate a backup? Is there any generally practiced way of doing that? Or what do you mean when you say tested backups? -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)

or something like that for such abnormal cases? -- Amit Langote -- 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] Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)

(100). Oh, okay, thanks! -- Amit Langote -- 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] Seq Scan cost shown to be (cost=10000000000.00..10000000001.10)

When one uses “enable_” settings to adjust planner behavior, PostgreSQL just sets really high costs for the operations affected (like the one you see). As SeqScan is the only possible way to execute your query, it is still choosen. I get it. Thanks! -- Amit Langote -- Sent via pgsql

Re: [GENERAL] pg_receivexlog 9.2 client working with 9.1 server?

pg_receievexlog with a 9.1 server. -- Amit Langote -- 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] There are many processes created and died frequently during PostgreSQl idle

forks autovacuum worker processes to perform vacuum activity. You might want to read more about them here: http://www.postgresql.org/docs/9.2/static/routine-vacuuming.html#AUTOVACUUM -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Human readable or full text of xlog (pg_xlog) for vs 9.2

PITR? -- Amit Langote -- 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] Human readable or full text of xlog (pg_xlog) for vs 9.2

would have to wait for others to reply on this thread to point out any others means to recover your data, if any. -- Amit Langote -- 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] Why does row estimation on nested loop make no sense to me

-estimation-examples.html It also refers where in source code these table size estimations are done. Hope this helps. -- Amit Langote -- 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] Why does row estimation on nested loop make no sense to me

I also found one other discussion which has similar issues addressed: http://postgresql.1045698.n5.nabble.com/Bogus-nestloop-rows-estimate-in-8-4-7-td5710254.html -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Why does row estimation on nested loop make no sense to me

link. I would like to know if you still get the same row estimates (after explain) and also if possible, the value that is computed from that formula. Do they resemble each other? -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Comunication protocol

distinct phases of connection and subsequent operation over the established connection. -- Amit Langote -- 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] Why does row estimation on nested loop make no sense to me

On Sat, May 18, 2013 at 1:25 AM, Jeff Amiel becauseimj...@yahoo.com wrote: On most nested loops that I do explain/explain analyze on, the row estimation for the nested-loop itself is a product of the inner nodes of the nested loop. However in this case, I am stumped! explain select

Re: [GENERAL] Why does row estimation on nested loop make no sense to me

On Sat, May 18, 2013 at 1:47 AM, Jeff Amiel becauseimj...@yahoo.com wrote: - Original Message - From: Amit Langote amitlangot...@gmail.com To: Jeff Amiel becauseimj...@yahoo.com Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Friday, May 17, 2013 11:37 AM

Re: [GENERAL] Why does row estimation on nested loop make no sense to me

. That aside, yes - I did analyze and tweak stats target during experimentation - no change. Did you also check select count(*) on both the relations and found related numbers? -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] PAM implementation in PG 9.2.3

authentication code in the backend that needs to resolved. This has been reported on pgsql-hackers. -- Amit Langote -- 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] PAM implementation in PG 9.2.3

, psql won't connect before it accepts password. You can try this (and see that no authentication failure is logged) I think log entries just mean the authentication has failed with PAM-specific error message. -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Position() Bug ? In PostgreSQL 9.2

manojadinesh.blogspot.com -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Position() Bug ? In PostgreSQL 9.2

similar, it returns first index (which is 1) of the main string (haystack!). Although this does not answer if it's a bug or not, I tend to think it is deliberate. -- Amit Langote -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] Confusing comment in xlog.c or am I missing something?

I was just going through the xlog.c and I came across following which confused me: Given, src/include/access/xlogdefs.h #define XLogSegsPerFile (((uint32) 0x) / XLogSegSize) #define XLogFileSize(XLogSegsPerFile * XLogSegSize) Also, typedef struct XLogRecPtr { uint32