Re: [GENERAL] [HACKERS] Online DW

/docs/latest/tutorial-en.html#replication-config Read full documentation, above url cites point directly to the replication part but read full documentation. HTH > Thanks > Sridhar > Opentext --- --- Eduardo Morras -- Sent via pgsql-general mailing list (pgsql-general@postgr

Re: [GENERAL] [HACKERS] Online DW

/docs/latest/tutorial-en.html#replication-config Read full documentation, above url cites point directly to the replication part but read full documentation. HTH > Thanks > Sridhar > Opentext --- --- Eduardo Morras -- Sent via pgsql-general mailing list (pgsql-general@postgr

Re: [GENERAL] Streaming Replica Master-Salve Config.

use a bouncer like pgbouncer. It can run on the same server. > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general --- --- Eduardo Morras -- Sent via pgsql-

Re: [GENERAL] Streaming Replica Master-Salve Config.

On Fri, 5 Aug 2016 12:43:43 -0700 John R Pierce wrote: > On 8/4/2016 9:15 AM, Eduardo Morras wrote: > > If you set max_connections too high, those connections will > > compete/figth for same resources, CPU processing, I/O to disks, > > Memory and caches, Locks, and postgres

Re: [GENERAL] Clustered index to preserve data locality in a multitenant application?

ging Partner > +33 6 03 00 25 34 > www.vocationcity.com ? Recruitment & application tracking software > www.gardentechno.com ? Consulting & software engineering --- --- Eduardo Morras -- 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] Clustered index to preserve data locality in a multitenant application?

On Wed, 31 Aug 2016 17:33:18 +0200 Nicolas Grilly wrote: > Eduardo Morras wrote: > > > > Check BRIN indexs, they are "designed for handling very large > > tables in which certain columns have some natural correlation with > > their physical location within t

Re: [GENERAL] postgres MultiXact 9.3 corruption resolved but advice needed

"MultiXactId NNN has not been created yet -- apparent wraparound". --- --- Eduardo Morras -- 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] Storing files: 2.3TBytes, 17M file count

sh (Tiger Tree Hash often) of file content to allow multi peer to peer copy. > Regards, > Thomas Güttler > > > Related question at rsnapshot mailing list: > https://sourceforge.net/p/rsnapshot/mailman/rsnapshot-discuss/thread/57a1a2f3.5090...@thomas-guettler.de/ > -- >

Re: [GENERAL] pg_dump slower than pg_restore

there's nothing wrong. All transparent compressed objects stored in database, toast, lo, etc.. is transparently decompressed while pg_dump access them and then you gzip it again. I don't know why it doesn't dump the compressed data directly. > > Thanks, >

Re: [GENERAL] large table

GB size tables with few rows and a permament 'IDLE in TRANSACTION' stops any autovacuum. --- --- Eduardo Morras -- 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] Ever increasing pg_clog disk usage v8.4

> which is the problem > > Does anyone know how I can reclaim the every growing ramdisk space? It may be a bug corrected in newer 8.4 versions, update. A fast hack will be close the application connected to PostgreSQL, it will close the transactions. Better, rewrite your app to op

Re: [GENERAL] reducing number of ANDs speeds up query

stgreSQL to do first the initial "WHERE ... AND > ... AND" and then the last "AND b.value=..." on the (very small) result? > > Thank you and kind regards, > T. --- --- Eduardo Morras -- 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] reducing number of ANDs speeds up query RESOLVED

state. > T. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general --- --- Eduardo Morras -- 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_Restore

On Mon, 21 Jan 2013 22:16:00 +0530 bhanu udaya wrote: > Hello All, > Can we achieve this template or pg_Restore in less than 20 minutes time. Any > more considerations. Kindly reply. Thanks and RegardsRadha Krishna From: > udayabhanu1...@hotmail.com Perhaps you can use the ntfs snapshot featu

Re: [GENERAL] Gitorious

tax and mysql tricks. > Elle > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general --- --- Eduardo Morras -- 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] PostgreSQL: CPU utilization creeping to 100%

dware errors) reconstructing the raidz should show what you say. Check the output of #zpool status when the "cpu storm" happens. c) If you do a simple #top -U postgres (or the user that executes your postgres server), what does the STATE column show? Check that to know the kernel st

Re: [GENERAL] Backup advice

On Mon, 8 Apr 2013 10:40:16 -0500 Shaun Thomas wrote: > > Anyone else? > If his db has low inserts/updates/deletes he can use diff between pg_dumps (with default -Fp) before compressing. --- --- Eduardo Morras -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] Backup advice

On Mon, 15 Apr 2013 19:54:15 -0700 Jeff Janes wrote: > On Tue, Apr 9, 2013 at 3:05 AM, Eduardo Morras > > > wrote: > > > On Mon, 8 Apr 2013 10:40:16 -0500 > > Shaun Thomas > 'stho...@optionshouse.com');>> wrote: > > > > > >

[GENERAL] What's wrong with postgresql.org domain?

I get Godaddy's page saying it's free --- --- Eduardo Morras -- 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] What's wrong with postgresql.org domain?

mirrors.postgresql.org Address: 217.196.149.50 In 87.238.57.232 (Sweeden) 98.129.198.126(San Antonio,TX) and 217.196.149.50(Saltzburg) i get lighttpd default page. Perhaps a miss configuration on my ISPs dns. I'll try with home connection this afternoon. Thanks --- --- Eduardo Morras

Re: [GENERAL] Storing small image files

ront-end developers to whip out some PHP > just to be safe. > > Thanks to all! --- --- Eduardo Morras -- 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] Replication with Drop: could not open relation with OID

iew to the table that enforces current data version. Add new data using a new data version number. When you want to switch, update the view and delete old version data. You must add version column as the first index entry on the indexes you create. HTH > > Regards --- --- Eduardo M

Re: [GENERAL] Postgresql, sql client and I/O exceptions

if you might know the cause it would > help me tremendously. > If it's under Linux, check that Out of Memory Killer don't slain some postmaster process. Disable it and try again. > -- > Paul Anthony Maddock --- --- Eduardo Morras -- 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] new instance of postgres on windows

ith the configuration you want. Run. --- --- Eduardo Morras -- 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] Postgres 8.2 Memory Tuning

At 08:56 16/06/2009, you wrote: Hi, I need to measure the memory used by postgres under various loads in my application.How to calculate the exact memory used by postgres for OS:Windows as well as linux ? Download ProcessXP from Microsoft (before it was from Sysinternals). There you

[GENERAL] WAL and master multi-slave replication

Hello: I'm currently building a Pg multiserver and have a question about the possibility of working with WAL in a multislave environment. I have few master servers (write only) and multiple slave servers (read only). I want to write the WAL files from masters in a central postgres and th

Re: [GENERAL] WAL and master multi-slave replication

At 19:05 24/06/2009, Alvaro Herrera wrote: Eduardo Morras wrote: Hi, > I'm currently building a Pg multiserver and have a question about the > possibility of working with WAL in a multislave environment. > > I have few master servers (write only) and multiple slave servers

Re: [GENERAL] WAL and master multi-slave replication

At 19:25 24/06/2009, you wrote: On Wed, Jun 24, 2009 at 11:22 AM, Eduardo Morras wrote: > Yes, there will be 3 masters recolleting data (doing updates, inserts and > deletes) for now and 5 slaves where we will do the searches. The slaves must > have all the data recollected by the 3

Re: [GENERAL] Postgresql Web Hosting

At 01:22 30/09/2009, Matt Friedman wrote: >Hi, > >I'm trying to migrate a site to a new hosting company. The backend >uses postgresql 8 and php. > >Anyone have thoughts on decent hosting companies for this sort of >thing? I'm just looking at shared hosting as this isn't a resource >intensive site.

Re: [GENERAL] Call for design: PostgreSQL mugs

a cool idea? Please let us know. Either reply here or send > an email to pgeu-bo...@postgresql.org. A big yellow elephant? Perhaps with a nice smile? Oh it's already taken ;) > > > Thanks, --- --- Eduardo Morras -- Sent via pgsql-general mailing list (pgsql-general@p

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

with "Elephant Inside" logo. --- --- Eduardo Morras -- 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] Call for design: PostgreSQL mugs

a cool idea? Please let us know. Either reply here or send > an email to pgeu-bo...@postgresql.org. CREATE OR REFILL mug{ id_owner INTEGER PRIMARY KEY, owner_name VARCHAR(40), CONSTRAINT id_owner PRIMARY KEY (mug), CONSTRAINT fk_content FOREIGN KEY (content) REFERENCES content (co

Re: [GENERAL] upgrade from 9.2.x to 9.3 causes significant performance degradation

ics says so. b) Did you configure postgresql.conf on 9.3.0 for your server/load? Perhaps it has default install values. c) What does logs say? > thanks > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > htt

Re: [GENERAL] How to compare the results of two queries?

- Not sure about this one because uses COUNT on a hstore data column. > Thanks in advance. > Best regards from Cuba. --- --- Eduardo Morras -- 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] High Level Committers Wanted

to spare in funky threats ;) --- --- Eduardo Morras -- 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] Upgrading from 9.2 to 9.3 causes performance degradation

n Times (average time of three executions, in seconds) > > ++---+---+ > | Server | 9.2 | 9.3 | > ++---+---+ > | Old| 129 | 216 | > ++---+---+ > | New| 118 | 275 | > ++---+---+ > > Thank

Re: [GENERAL] Vacuum as "easily obtained" locks

At 16:35 03/08/2011, Michael Graham wrote: Yeah it said it last ran yesterday (and is currently running now), but I did I notice in the log: 2011-08-02 19:43:35 BST ERROR: canceling autovacuum task 2011-08-02 19:43:35 BST CONTEXT: automatic vacuum of table "traffic.public.logdata5queue" Which

Re: [GENERAL] Vacuum as "easily obtained" locks

At 19:32 03/08/2011, you wrote: On 08/03/11 10:21 AM, Eduardo Morras wrote: One question, while you run your tests, does "IDLE IN TRANSACTION" messages happen? If you run your tests with a permanent connection to database, the tables are locked and autovacuum cannot work. its not t

Re: [GENERAL] looking for a faster way to do that

At 09:45 23/09/2011, haman...@t-online.de wrote: A single anchored query select * from items where code ~ '^ABC'; does indeed use the index to retrieve data. So I wonder whether there might be a different approach to this problem rather than pattern matching. I recall I had a similar problem

Re: [GENERAL] looking for a faster way to do that

At 14:12 23/09/2011, haman...@t-online.de wrote: Eduardo Morras wrote: >> You can try these, i doubt they will use any index but its a >> different approach: >> >> select * from items where length(items.code)<>length(rtrim(items.code,'ABC')); >>

Re: [GENERAL] Speed of lo_unlink vs. DELETE on BYTEA

At 07:43 25/09/2011, Reuven M. Lerner wrote: Hi, everyone. Daniel Verite wrote: It would thus appear that there's a slight edge for dumping bytea, but nothing super-amazing. Deleting, however, is still much faster with bytea than large objects. The pro

Re: [GENERAL] looking for a faster way to do that

At 08:04 25/09/2011, haman...@t-online.de wrote: >> select * from items where regexp_matches(items.code,'(ABC) (DE1) >> (any_substring)')<>{}; >> Hi Eduardo, it is clear that scanning the table once with a list of matches will outperform rescanning the table for every string wanted. Now, my p

Re: [GENERAL] looking for a faster way to do that

At 18:18 26/09/2011, you wrote: Eduardo Morras wrote: >> >> At 08:04 25/09/2011, haman...@t-online.de wrote: >> >> > >> select * from items where regexp_matches(items.code,'(ABC) (DE1) >> > >> (any_substring)')<>{}; >>

Re: [GENERAL] postgres for OLAP & data mining

At 16:12 30/09/2011, Dario Beraldi wrote: Hello, I'm looking for some information (guidelines, docs, tutorials, etc...) about using postgres for OLAP, data mining, data warehousing. The sort of questions I'm trying to answer are on the lines of - What tools/SQL commands are available? - How s

Re: [GENERAL] Searching for "bare" letters

At 01:25 02/10/2011, Reuven M. Lerner wrote: Hi, everyone. I'm working on a project on PostgreSQL 9.0 (soon to be upgraded to 9.1, given that we haven't yet launched). The project will involve numerous text fields containing English, Spanish, and Portuguese. Some of those text fields w

[GENERAL] UFS2 Snapshots and Postgres

Hi everyone, I'm using FreeBSD 9 for Postgres and want to know if these actions are safe for make a backup of the database: a) call pg_start_backup('b1') b) take an UFS2 snapshot of data files c) call pg_stop_backup() d) change to the snapshot dir and rsync/dd/dump/transfer it to backup file

Re: [GENERAL] UFS2 Snapshots and Postgres

At 15:16 25/06/2012, you wrote: On 6/25/2012 7:35 AM, Eduardo Morras wrote: Hi everyone, I'm using FreeBSD 9 for Postgres and want to know if these actions are safe for make a backup of the database: a) call pg_start_backup('b1') b) take an UFS2 snapshot of dat

Re: [GENERAL] PostGIS in a commercial project

At 09:26 21/10/2011, Thomas Kellerer wrote: Hello, we are using PostgreSQL in our projects and would like to integrate PostGIS as well. Now PostGIS is licensed under the GPL and I wonder if we can use it in a commercial (customer specific) project then. The source code will not be made open

Re: [GENERAL] odbc_fdw

At 16:27 28/11/2011, you wrote: Hi there! I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in a VMware under Win7). I followed the steps in this guide: www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from-source It seems to work (I can run the server and co

Re: [GENERAL] Hope for a new PostgreSQL era?

Sorry for delay, I wonder if the prioritisation could be done using nice - each backend is a separate process, so why not to do 'nice(10)' for low priority processes or something like that. Yes, to a limited degree you can prioritise queries using nice and ionice, but it's awkward because

Re: [GENERAL] Refine Form of My querry

At 11:11 29/12/2011, you wrote: Hi every1 how are u all??? Members i am new in postgres and want to work on pgrouting but i am facing some issue with it. Will u please help me??? I have loaded my line shapefile in pgadmin environment, which creates a table name 'Route', but when i made a query 'C

Re: [GENERAL] Don't Thread On Me (PostgreSQL related)

At 00:32 27/01/2012, you wrote: There are cases where intraquery parallelism would be helpful. As far as I understand it, PostgreSQL is the only major, solid (i.e. excluding MySQL) RDBMS which does not offer some sort of intraquery parallelism, and when running queries across very large datab

Re: [GENERAL] Backing up through a database connection (not pg_dump)

At 01:05 27/03/2012, Tim Uckun wrote: Is there a way to backup a database or a cluster though a database connection? I mean I want to write some code that connects to the database remotely and then issues a backup command like it would issue any other SQL command. I realize the backups would nee