Hello,
I would like to implement parallel DB Architecture in postgres.I
came across various parallel architectures shared memory,shared disk,shared
nothing,hierarchical.But I am unaware of how to implement one of these in real
time system.Can you guys help me in this aspect?
I just had a brief outage on a production server running 8.3.6, which
I suspect was triggered by me running a table bloat report making lots
of pgstattuple calls.
The first I got of it was the script I'd just kicked off died:
could not open segment 1 of relation 1663/16409/11088101 (target block
Hello
We use plProxy (RUN ON ALL) to run queries in parallel.
We split our database into 16 shards and distributed it over 4 servers.
So now we are running queries on 16 cpu's in parallel :)
regards,
Asko
On Mon, Mar 30, 2009 at 9:20 AM, aravind chandu avin_frie...@yahoo.comwrote:
Hello,
Thomas,
When I start the servers, I use different ports via the -p option. Is
that equivalent to using different listener ports in postgresql.conf?
Thanks,
Eric
On Mar 28, 2009, at 3:51 PM, Thomas Kellerer wrote:
Adrian Klaver wrote on 28.03.2009 23:37:
On Saturday 28 March 2009 3:27:15
On Mon, Mar 30, 2009 at 1:51 AM, ray ray.jos...@cdicorp.com wrote:
I am trying to get Python 2.6 and PostgreSQL 8.3 to work together
under Windows 2000.
When I try to add Python to PostgreSQL via:
createlang plpythonu dbname
But when doing so, I get an error:
createlang: language
Devrim GÜNDÜZ, 28.03.2009 10:02:
As we are moving very close to 8.4 beta, please join us for testing 8.4
release.
I just released new RPM sets, which is based on Mar 27 CVS snapshot.
Please note that these packages are **not** production ready. They are
for Fedora 9,10 and RHEL/CentOS 5. I have
On Mon, Mar 30, 2009 at 7:56 AM, Thomas Kellerer spam_ea...@gmx.net wrote:
Devrim GÜNDÜZ, 28.03.2009 10:02:
As we are moving very close to 8.4 beta, please join us for testing 8.4
release.
I just released new RPM sets, which is based on Mar 27 CVS snapshot.
Please note that these packages
On Sun, Mar 29, 2009 at 08:44:59PM -0400, V S P wrote:
The same problem was with my set client encoding (my other email)
both were related problem to the fact that PG I have to issue commits
even for the 'non sql' statements.
That's something between you and your database driver. PostgreSQL by
On Behalf Of Asko Oja
Hello
We use plProxy (RUN ON ALL) to run queries in parallel.
We split our database into 16 shards and distributed it over 4 servers.
So now we are running queries on 16 cpu's in parallel :)
Wow.. query time improved How many fold? Any idea?
--
Sent via pgsql-general
Thanks for your reply guys.My aim is to run multiple queries.Will joins come
under multiple queries? or it just mean two or more different queries like one
select statement and another select statement? Does postgresql itself supports
to run multiple queries or we have to use pgpool-II tool?
On Tue, Mar 24, 2009 at 4:53 PM, Jasen Betts ja...@xnet.co.nz wrote:
On 2009-03-18, cifroes cifr...@netcabo.pt wrote:
This is a multi-part message in MIME format.
--_=_NextPart_001_01C9A7E6.B32BBA87
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Cédric Villemain a écrit :
Martin Pitt a écrit :
Cédric Villemain [2009-03-15 23:58 +0100]:
Any plan for 8.4 pre-beta package ? (Devrim Gunduz provide usefull rpm
package,
I'd like to have the same in debian).
Can it be in the experimental
Hello Cédric,
Cédric Villemain [2009-03-30 12:08 +0200]:
I have started some work on that.
Whoops, sorry. So did I yesterday evening. I just fixed the branch
enough to build now [1].
I just need to update postgresql-common to work with 8.4. Some things
changed, e. g. pg_controldata doesn't
Dave Page, 30.03.2009 10:34:
EnterpriseDB used to provide 8.4 builds for Windows, but the page I
bookmarked does not longer work.
Does anybody know if EnterpriseDB stopped this service?
No - in fact we refreshed the builds just a few days ago:
On 30/03/2009 07:18, aravind chandu wrote:
Thanks for your reply guys.My aim is to run multiple queries.Will
joins come under multiple queries? or it just mean two or more
Not sure what you're getting at herea query that includes a JOIN is
still one query.
different queries like one
Is it possible to have 2 gin indexes and OR the search of them?
Problem is, I need to search 5 columns and there is limitation of only 4
weights, so I want to have one index of 4 vectors and second index of 1
vector and need to OR the search.
When I try to search them separately, or use AND, it
Dave Page, 30.03.2009 14:28:
On Mon, Mar 30, 2009 at 1:06 PM, Thomas Kellerer spam_ea...@gmx.net wrote:
OK, thanks. I received very strange error messages last week when I accessed
that page. (Velocity Template not found and similar errors). But now it's
working.
Yeah, we had a big website
On Mon, Mar 30, 2009 at 1:06 PM, Thomas Kellerer spam_ea...@gmx.net wrote:
OK, thanks. I received very strange error messages last week when I accessed
that page. (Velocity Template not found and similar errors). But now it's
working.
Yeah, we had a big website update and that page got messed
Bruno Baguette wrote:
Hello !
I have a table that contains two timestamps (and some other fields that
does not matter here).
the_table
--
pk_planning_id == INT8 (primary key)
timestamp_start == (not null timestamp without time zone)
timestamp_stop =+ (not null timestamp without
Markus Wanner wrote:
Hi,
Martijn van Oosterhout wrote:
And fsync better do what you're asking
(how fast is just a performance issue, just as long as it's done).
Where are we on this issue? I've read all of this thread and the one on
the lvm-linux mailing list as well, but still don't
esemba ese...@gmail.com writes:
Is it possible to have 2 gin indexes and OR the search of them?
Sure. They need to be fairly restrictive though, or the planner might
decide that a seqscan is cheaper.
regards, tom lane
--
Sent via pgsql-general mailing list
On Mon, Mar 30, 2009 at 2:52 PM, Joseph, Ray ray.jos...@cdicorp.com wrote:
Dave,
I am sorry that I was not clear. I want to use 2.6 but the stack seems to
direct me to 2.5.
That's exactly what I understood from your email - however my fingers
weren't working properly at that time in the
On Sunday 29 March 2009 7:59:19 pm Eric Smith wrote:
Thomas,
When I start the servers, I use different ports via the -p option. Is
that equivalent to using different listener ports in postgresql.conf?
Thanks,
Eric
I think you are going to have to show us the exact command you are using.
Adrian Klaver akla...@comcast.net writes:
I think you are going to have to show us the exact command you are using.
What *I* want to see is the postmaster log, which should certainly
contain an error message explaining why it failed to start.
regards, tom lane
--
Sent
Hi,
In the next project I'm going to have a number of colums in my tables,
but I don't know how many, they change. They all use integers as
datatype though.. One day, I get 2 new columns, a week later I loose
one column, and so on in a random pattern.
I will most likely have a few million rows of
Hello:
I have a problem with juding some words contain chinese word.
I found that with oracle.but i can't find it in postgresql.
oracle? has acsiistr and lengthb to deal with it.i wonna to know postgresql
how to !
??? thx !
On Mar 30, 2:55 am, dp...@pgadmin.org (Dave Page) wrote:
On Mon, Mar 30, 2009 at 1:51 AM, ray ray.jos...@cdicorp.com wrote:
I am trying to get Python 2.6 and PostgreSQL 8.3 to work together
under Windows 2000.
When I try to add Python to PostgreSQL via:
createlang plpythonu dbname
But
Without knowing to much currently..
can you create one table with enough columns?
Then create a view to query the table and 'reflect' the changes and
correct column names.
Using rule you could also even simulate the update to the view and
update to the correct columns.
This so that you
IMHO one of the possible solutions is to review the table and storage
externaly the
stable columns. So when you run 'alter table ' it was less
expensive (i never
test this, but maybe its true :P )
So the mutable columns will be separated from the others and the
phisical structure
could be
On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
Hi,
In the next project I'm going to have a number of colums in my tables,
but I don't know how many, they change. They all use integers as
datatype though.. One day, I get 2 new columns, a week later I loose
one column, and so on in a
To run servers at diferent ports you must use postgres binary.
postgres -D data1 -p 5432 -l logfile
postgres -D data2 -p 5433 -l logfile
I never used pg_ctl to run postgres and don't ask me why.
2009/3/28, Eric Smith esm...@haas-software.com:
All,
I'm trying to run two database clusters
Well, not as such. Except that deleting a column doesn't really delete
it, it hides it, so it never really goes away. So the number of
columns in your table will only go up and eventually you're going to
reach the point (around 1600 IIRC, probably earlier) where it will
simply stop working.
On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
Hi,
In the next project I'm going to have a number of colums in my tables,
but I don't know how many, they change.
Stop right there. You need to get some sanity into your project,
either by changing that requirement, or by not using an
From: michaelblack75...@hotmail.com
To: gentosa...@gmail.com
Subject: RE: [GENERAL] [GENEAL] dynamically changing table
Date: Mon, 30 Mar 2009 16:05:52 +
The simplest way is to plan for the maximum number of columns that will be
required (say 14 - 2 weeks of data assuming that is
- Emanuel Calvo Franco postgres@gmail.com wrote:
To run servers at diferent ports you must use postgres binary.
postgres -D data1 -p 5432 -l logfile
postgres -D data2 -p 5433 -l logfile
That is not true. You can set the port in the postgresql.conf for each cluster
to be
I am sorry, but it seems that I replied to only one of you instead of to the
mailing list.
I am just about to install a version on my Server computer (Windows web
server 2008 x64) and I am stuck on what I should go with.
I have been developing on the standard postgreSQL but like that the
2009/3/30 David Fetter da...@fetter.org:
On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
Hi,
In the next project I'm going to have a number of colums in my tables,
but I don't know how many, they change.
Stop right there. You need to get some sanity into your project,
either by
I have a query that converts a string to an array with the
string_to_array function. Sometimes the input is an empty string (not a
null, but a string of zero-length). I had expected the result to be a
one-element array with an empty string as the first and only element but
instead it returned
On Mon, Mar 30, 2009 at 7:36 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
I am sorry, but it seems that I replied to only one of you instead of to the
mailing list.
I am just about to install a version on my Server computer (Windows web
server 2008 x64) and I am stuck on what I should go
On Mon, Mar 30, 2009 at 11:04:06AM -0700, David Fetter wrote:
On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
Hi,
In the next project I'm going to have a number of colums in my tables,
but I don't know how many, they change.
Stop right there. You need to get some sanity into your
2009/3/31 A B gentosa...@gmail.com:
One option is, put it in a db as a huge text (or in textfiles, one
per object) and parse it when you need it. That might also work.
Why are you demanding sanity? I need crazy ideas to get this to work ;-)
Heh ... sorry, but dynamic table just SCREAMS
On Mon, Mar 30, 2009 at 08:50:59PM +0200, A B wrote:
Well, the requirement is: keep a lot of data stored, don't loose any
of it, and you will not know what you will have to store (changing
number of fields and of different types)
As you've not said anything about getting said data back; it
Hmm, cant find it.. but.. if I install the regular (not plus), could I later
upgrade easily to other versions ? Is that possible? In that case I could
just start with the one I already are familiar with.
Jen
On Mon, Mar 30, 2009 at 9:03 PM, Dave Page dp...@pgadmin.org wrote:
On Mon, Mar 30,
On Mon, Mar 30, 2009 at 8:20 PM, Jennifer Trey jennifer.t...@gmail.com wrote:
Hmm, cant find it.. but.. if I install the regular (not plus), could I later
upgrade easily to other versions ? Is that possible? In that case I could
just start with the one I already are familiar with.
It's quite
Is it possible that what you want is a lookup table with a string index,
i.e. attribute-value pairs?
If so, that would be represented as a hash in Perl, or a map in C++. In
a database, you could design a very simple schema for it.
Or do you just have unclear requirements, as others have
Point me to latest JDBC for pgSQL (plus) standard server?
We're running PG 8.1 on CentOS 5.0. When postgres starts the following
processes apparently required by the DB itself get created:
postgres 23784 1 0 13:55 ?00:00:00 /usr/bin/postmaster -p 5432 -D
/var/lib/pgsql/data
postgres 23786 23784 0 13:55 ?00:00:00 postgres:
Jennifer Trey wrote on 30.03.2009 21:39:
Point me to latest JDBC for pgSQL (plus) standard server?
http://jdbc.postgresql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
It's a normal pg connection server created by our own code. Nothing native to
pg startup.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Eshelman, James
Sent: Monday, March 30, 2009 3:29 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL]
ray wrote:
I am sorry for not providing a clear description of my problem. I
want to us Python 2.6 but the PLPython seems to me looking for 2.5
which is not on my machine. Is there a way to have PostgreSQL work
with Python 2.6?
Recompile PostgreSQL, or at least the PL/Python extension, to
Eshelman, James wrote:
We’re running PG 8.1 on CentOS 5.0. When postgres starts the following
processes apparently required by the DB itself get created:
postgres 23784 1 0 13:55 ? 00:00:00 /usr/bin/postmaster -p 5432 -D
/var/lib/pgsql/data
postgres 23786 23784 0 13:55 ? 00:00:00
Hi,
Im reading from an Oracle table and inserting the values to a postgres table
thro' jdbc. Everything works fine except for the BLOB data in Oracle.
My code snippet ...
while (rs1.next())
{
for (int m=1;m=colCount;m++)
{
Hi,
During the development of my application I once, somehow through an
installed postgresql software got me to a page where I could find
information on how to tune my db.
I can't seem to find to that link again. I think it was to a page within the
EnterpriseDB but that page seems to have
2009/3/30 Jennifer Trey jennifer.t...@gmail.com:
Hi,
During the development of my application I once, somehow through an
installed postgresql software got me to a page where I could find
information on how to tune my db.
I can't seem to find to that link again. I think it was to a page within
Using Postgresql 8.2.11 on Ubuntu 7.10.I am writing a J2EE project but do not want user specific schemas because this application sits on a production floor and any production employee can walk to a workstation and access the database to punch work time. I know that the public schema is not
You are fetching an Oracle LOB locator. I am not a guru of OCI let alone
JDBC but AFAIK you should create a LOB descriptor, bind it to the locator
and load the LOB data that you can insert into postgres.
On Mar 30, 2009, at 10:14 , shiguoying wrote:
Hello:
I have a problem with juding some words contain chinese word.
I found that with oracle.but i can't find it in postgresql.
oracle? has acsiistr and lengthb to deal with it.i wonna to know
postgresql how to !
??? thx !
Hi all!
I'm developing an algorithm with PL/PGSQL using statistical operations from
a table. I have several differences between expected results and the results
generated by the function.
I want to know if there are differences in arithmetic operation sintax or if
there's any special
That's it!
Log file says could not create shared memory segment. It also says
that I should change max_connections or shared_buffers.
Error message claims that max_connections is 23, but postgresql.conf
has this listed as 20.
Error message claims that shared_buffers is 300, but
I don't think I understand how PG implements fulltext searching or if my
search actually needs to use fulltext search.
basically, I have a btree index on a SERIAL_NUMBER which is of sort like
ABC12345 or AAA123434 or AAB131441
I would like to have search on the specific text of the SERIAL_NUMBER
Stuart Bishop stu...@stuartbishop.net writes:
I just had a brief outage on a production server running 8.3.6, which
I suspect was triggered by me running a table bloat report making lots
of pgstattuple calls.
The first I got of it was the script I'd just kicked off died:
could not open
Eric Smith eric_h_sm...@mac.com writes:
Log file says could not create shared memory segment. It also says
that I should change max_connections or shared_buffers.
Error message claims that max_connections is 23, but postgresql.conf
has this listed as 20.
The autovacuum workers get added
Eric Smith eric_h_sm...@mac.com writes:
Following the queue on the postgres web page, I created /etc/
sysctl.conf and added the following five entries:
kern.sysv.shmmax=4194304
kern.sysv.shmmin=1
kern.sysv.shmmni=32
kern.sysv.shmseg=8
kern.sysv.shmall=1024
But when I try to start two
Ahhh! Can't seem to make this go away!
Here is the log file entry:
FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=5432001, size=4030464,
03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory
Steve Crawford scrawf...@pinpointresearch.com writes:
I have a query that converts a string to an array with the
string_to_array function. Sometimes the input is an empty string (not a
null, but a string of zero-length). I had expected the result to be a
one-element array with an empty
Just because a result is unexpected
does not mean its an incorrect result. No postgresql follows the order
of operations as expected.
Now looking at the 2 For loops the First does not have a where clause
and the Second has a Where not null this could be the cause of the
problem.
Another
On Tue, Mar 31, 2009 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Stuart Bishop stu...@stuartbishop.net writes:
I just had a brief outage on a production server running 8.3.6, which
I suspect was triggered by me running a table bloat report making lots
of pgstattuple calls.
The first I got
Tom Lane wrote:
I agree this seems less than consistent though, especially seeing
that you *don't* get a null for a zero-length separator, which if
anything is a more poorly defined case.
I doubt it'd be a good idea to back-patch a change for this,
but I could see altering the definition for
Stuart Bishop stu...@stuartbishop.net writes:
On Tue, Mar 31, 2009 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What's the actual size of that relation now? Â Is it growing rapidly?
(I'm trying to figure out whether those writes *should* have succeeded,
or whether the block numbers were
On Mar 30, 2009, at 8:26 PM, Tom Lane wrote:
Does anyone want to argue for keeping it the same? Or perhaps
argue that a zero-element array is a more sensible result than
a one-element array with one empty string? (It doesn't seem
like it to me, but maybe somebody thinks so.)
Hrm. There
On Tue, Mar 31, 2009 at 11:10 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Stuart Bishop stu...@stuartbishop.net writes:
On Tue, Mar 31, 2009 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What's the actual size of that relation now? Is it growing rapidly?
(I'm trying to figure out whether those
71 matches
Mail list logo