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
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
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 (read
only). I want
At 19:25 24/06/2009, you wrote:
On Wed, Jun 24, 2009 at 11:22 AM, Eduardo Morrasemor...@s21sec.com 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
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.
I use
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
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 that tables
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
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'));
select * from items where strpos(items.code,'ABC')=0
At 07:43 25/09/2011, Reuven M. Lerner wrote:
Hi, everyone. Daniel Verite
mailto:dan...@manitou-mail.orgdan...@manitou-mail.org 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
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 problem
At 18:18 26/09/2011, you wrote:
Eduardo Morras nec...@retena.com wrote:
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
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
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
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
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
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
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
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
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
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
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 data files
c) call
.
Thanks to all!
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
version column as the first index entry on the indexes you create.
HTH
Regards
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-
I'm researching the issue myself, but 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
the times you want with the
configuration you want.
Run.
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
an email to pgeu-bo...@postgresql.org.
A big yellow elephant? Perhaps with a nice smile? Oh it's already taken ;)
Thanks,
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Inside logo.
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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 (content_id)
)WITH (
OIDS=FALSE
);
Thanks,
--- ---
Eduardo
?
thanks
--
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 emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
COUNT on a hstore data column.
Thanks in advance.
Best regards from Cuba.
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
=... on the (very small) result?
Thank you and kind regards,
T.
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 21 Jan 2013 22:16:00 +0530
bhanu udaya udayabhanu1...@hotmail.com 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
@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
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 state
of the process.
d) Do you use the standard values for zfs? Specially arc values.
--- ---
Eduardo Morras emorr...@yahoo.es
On Mon, 8 Apr 2013 10:40:16 -0500
Shaun Thomas stho...@optionshouse.com 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 emorr...@yahoo.es
--
Sent via pgsql-general mailing
On Mon, 15 Apr 2013 19:54:15 -0700
Jeff Janes jeff.ja...@gmail.com wrote:
On Tue, Apr 9, 2013 at 3:05 AM, Eduardo Morras
emorr...@yahoo.esjavascript:_e({}, 'cvml', 'emorr...@yahoo.es');
wrote:
On Mon, 8 Apr 2013 10:40:16 -0500
Shaun Thomas stho...@optionshouse.com javascript:_e
I get Godaddy's page saying it's free
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
: www.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 emorr...@yahoo.es
money to
spare in funky threats ;)
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
|
++---+---+
| Old| 129 | 216 |
++---+---+
| New| 118 | 275 |
++---+---+
Thanks,
L
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
access
them and then you gzip it again. I don't know why it doesn't dump the
compressed data directly.
Thanks,
David
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
'IDLE in TRANSACTION' stops any autovacuum.
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to PostgreSQL, it will
close the transactions. Better, rewrite your app to open/close transactions,
using BEGIN/END.
Regards,
As final note, why don't use Sqlite3 for embedded instead PostgreSQL?
William Powrie
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list
http://www.pgpool.net/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 <emorr...@yahoo.es>
--
Sent v
http://www.pgpool.net/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 <emorr...@yahoo.es>
--
Sent v
On Fri, 5 Aug 2016 12:43:43 -0700
John R Pierce <pie...@hogranch.com> 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
e say and 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 <emorr...@yah
On Wed, 31 Aug 2016 17:33:18 +0200
Nicolas Grilly <nico...@vocationcity.com> wrote:
> Eduardo Morras wrote:
>
>
> > Check BRIN indexs, they are "designed for handling very large
> > tables in which certain columns have some natural correlation with
> > th
6 03 00 25 34
> www.vocationcity.com ? Recruitment & application tracking software
> www.gardentechno.com ? Consulting & software engineering
--- ---
Eduardo Morras <emorr...@yahoo.es>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ger 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/
> --
> T
ike "MultiXactId NNN has not
been created yet -- apparent wraparound".
--- ---
Eduardo Morras <emorr...@yahoo.es>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
53 matches
Mail list logo