Be warned that if you use python, expect it to be slow. Many basic
associative array operations are more than 10x slower than C++'s
comparative operations leading to long page execution time if you are
dealing with alot of data. I have written a simple web framework in
Python and XML, and it's a
The first thing you need to do is assess where your bottleneck is
going to be. Is it RAM? or CPU or IO? If your system is IO bound,
you are better off spending your $s on a good IO controller and lots
of drives that racking up the $$s with Expensive Opteron 275s or 250s,
when a 242 would do the j
William Yu wrote:
> On other note -- if you are thinking about SMP Opteron, you may
> actually get better performance from 1x275 (Dual Core 2.2ghz) versus
> 2x248 (2.2ghz). Full duals have twice the bandwidth but without good
> NUMA support, memory has to be interleaved between CPUs.
I thought th
[EMAIL PROTECTED] wrote:
> I am just curious to see if I can get Toad to connect to Postgresql.
> I have Access talking to it via ODBC. Toad is asking for Datasource
> and Location. I cant figure out what to put there. I have done some
> searching in google.
>
> Thanks for any suggestions.
Huang GeHua <[EMAIL PROTECTED]> writes:
> I want create a new database with the GB18030 encoding.But the
> pgAdminIII tell a error "GB18030 is not a valid encoding name".How can
> i do for it?
The docs say that GB18030 is supported as a client-side encoding only.
So pick any superset encoding (UTF
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Sun, Apr 24, 2005 at 11:05:57PM -0500, Tony Caduto wrote:
>> Is the syntax going to be exactly like it is in Oracle?
> I'm not familiar with the Oracle syntax and I don't know how close
> the PostgreSQL implementation is to being final, but here's an
>
From where can I download latest Postgres source (tar
file) for Fedora Core OS?
Regards
Dinesh Pandey
Hi Rich,
Guess now's the time. I'm trying to find a copy of pygresql to use, but
it's not easy (www.pygresql.org leads to druid.net and there's nothing
on the
page about pygresql). I'm learning python to use on a major project
here (but
the core libraries will remain in C) so I'd like to use th
I want create a new database with the GB18030 encoding.But the
pgAdminIII tell a error "GB18030 is not a valid encoding name".How can
i do for it?
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
I just now tried creating a second server with
pgadminIII. I am confused as to why one would have more than
one server. There does not seem to be any way to "switch" from one server
to another, or to log into one particular server (and not the other), or to
create tables specifically for
I went to http://www.pgexplorer.com
and downloaded their adm program for postgresql running on windows. The
site proclaims that it is now FREE, yet there is a moment of confusion when you
go to install and it talks about 30 evaluation period. Yet, once you install, if
you click on the REGIS
[EMAIL PROTECTED] wrote:
In my *utter* lack of enthusiasm over this option, I was gathering
ammunition for better hardware. I went to spec.org for speed comparisons,
and sun.com for price comparisons. Sun's *entry* level servers are more
powerful when running AMD CPUs.
Just in case people still h
On Apr 25, 2005, at 9:42 PM, Alvaro Herrera wrote:
Well, you can get a page header corruption on any release as long
as you
have faulty hardware ... RAM randomly dropping bits is not unheard of.
Have you run memtest?
No doubt. :) What I was asking was if 7.3.9 (or .8 or .7) had a
known issue
On Mon, Apr 25, 2005 at 08:24:03PM -0400, Eric B. Ridge wrote:
> Is page header corruption a known issue with 7.3.6 and should I
> upgrade to 7.3.9 at the same time that I'm restoring this table from
> backup?
Well, you can get a page header corruption on any release as long as you
have fault
On Sun, Apr 24, 2005 at 11:05:57PM -0500, Tony Caduto wrote:
>
> I saw that the recently released pl/java has the ablity to use IN, INOUT, and
> OUT parameters.
>
> Is the syntax going to be exactly like it is in Oracle?
I'm not familiar with the Oracle syntax and I don't know how close
the Post
We've got a PG 7.3.6 installation that just started receiving this
error:
2005-04-25 19:28:54 ERROR: Invalid page header in block 1110 of
the_table_name
We're also unable to dump that table using pg_dump. Postgres isn't
actually crashing, so I'm not sure how to get a backtrace out of i
Title: Message
WELL... I did that, and , LO AND BEHOLD,... there the darn thing
is now WHO in the name of Heaven would ever dream of going there and
right clicking?
Maybe it was some bloke called Gates who
couldn't figure out what to do with a single button mouse. After all, it is
"int
I am just curious to see if I can get Toad to connect to Postgresql.
I have Access talking to it via ODBC. Toad is asking for Datasource and
Location. I cant figure out what to put there. I have done some
searching in google.
Thanks for any suggestions.
"Dann Corbit" <[EMAIL PROTECTED]> writes:
> Probably, turning fsync off would be helpful, since you know it is
> read-only.
Wouldn't make any difference: a transaction that hasn't modified the
database doesn't bother to write any commit/abort WAL record at all.
regards, to
Probably, turning fsync off would be helpful, since you know it is
read-only.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Bruce Momjian
> Sent: Monday, April 25, 2005 3:01 PM
> To: David Parker
> Cc: postgres general
> Subject: Re:
David Parker wrote:
> If an application transaction is known to be read-only, is there any
> reason to prefer COMMIT or ROLLBACK for closing that transaction? Would
> there be any performance difference between the two commands?
Doesn't matter.
--
Bruce Momjian| http:/
If an
application transaction is known to be read-only, is there any reason to
prefer COMMIT or ROLLBACK for closing that transaction? Would there be any
performance difference between the two commands?
-
DAP--Da
On Apr 25, 2005, at 4:07 PM, Ruff, Jeffry C. SR. wrote:
Thanks for the reply. After making the change I now get the following
ERROR: unterminated string
CONTEXT: compile of PL/pgSQL function "group_list" near line 6
Ok make that
string text := ;
I'm now spoiled with dollar quoting :)
John DeS
On Mon, Apr 25, 2005 at 02:40:29PM -0500, Ruff, Jeffry C. SR. wrote:
>
> CREATE FUNCTION userinfo.group_list(text) RETURNS text AS'
>DECLARE
> rec RECORD;
> string text := NULL;
>BEGIN
> FOR rec IN SELECT * FROM userinfo.userdb_groups WHERE username = $1 LOOP
>
On Apr 25, 2005, at 3:40 PM, Ruff, Jeffry C. SR. wrote:
I found this function on line [Thanks to Jeff Eckermann and Juerg
Rietmann] that takes the results of a query and creates a comma
delimited string. However when I run it I get no values. Any help
would be appreciated. I apologize if this i
Please keep replies copied to the list so that other people can learn from
and comment on the discussion unless to have a good reason to make the
thread private.
On Mon, Apr 25, 2005 at 21:46:20 +0200,
Zlatko Matic <[EMAIL PROTECTED]> wrote:
> The reason for such crazy idea is my front-end MS Ac
On Apr 25, 2005, at 4:53 AM, Piotr Filipczuk wrote:
How to determinate column size in query in libpq? Especially when
column is declared for exapmle as varchar(64). PQfsize return -1
which mean that is variable and PQfmod returns 68.
68 - 4 is the correct size for varchar(64). There is 4 bytes o
Title: plpgsql function not working
I found this function on line [Thanks to Jeff Eckermann and Juerg Rietmann] that takes the results of a query and creates a comma delimited string. However when I run it I get no values. Any help would be appreciated. I apologize if this is the wrong forum
I guess I was thinking more of the "big picture"
Your right of course, for someone just fooling around at home or for a very
small business Access is great, but I am saying from experience that Access is
a poor choice for any kind of large project or corp use.
Access may be a poor choice for a De
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Tom Lane wrote:
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
So - does "tuple concurrently updated" make sense for "analyze"?
Yeah, it's entirely possible, if you have a background process that
might issue analyzes too (do you use autovacuum?). The error comes when
two sessions concurrently try
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> So - does "tuple concurrently updated" make sense for "analyze"?
Yeah, it's entirely possible, if you have a background process that
might issue analyzes too (do you use autovacuum?). The error comes when
two sessions concurrently try to update the
Tom Lane wrote:
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
During a batch load of records (using COPY) I got the following
postgres error today "tuple concurrently updated".
I don't think plain COPY could have produced that, since it only inserts
tuples. Tell us about triggers and foreign keys
On Mon, Apr 25, 2005 at 11:36:23AM -0400, Tom Lane wrote:
> > ---+---
> > 2005-04-24 22:25:51.669218+00 | 2005-04-24 23:25:51.669218+01
>
> It was not really possible in 7.1 either (nor any previous version).
> The secret to the above is th
John Browne wrote:
> Actually, that's a thought.. I could even create a bash wrapper
> script so I wouldn't have to type the database name each time. Will
> give it a shot.
>
> Thanks
>
> On 4/25/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> > On Mon, Apr 25, 2005 at 10:44:14AM -0500, John Brow
Actually, that's a thought.. I could even create a bash wrapper
script so I wouldn't have to type the database name each time. Will
give it a shot.
Thanks
On 4/25/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Mon, Apr 25, 2005 at 10:44:14AM -0500, John Browne wrote:
> >
> > Yeah, I know abou
Tom Lane wrote:
> John Browne <[EMAIL PROTECTED]> writes:
> > I was curious if there was a way to get the DDL for a particular table
> > from the psql client console?
>
> No. Try
> pg_dump -s -t tablename dbname
Oh, from psql: :-) (We really should have an easier way of show all
informat
I'm pretty sure that zeosdbo needs a version of Delphi with TDataset
support. I don't think that the Personal editions have that. You can use
the direct access parts of Zeos with the personal editions but then you
might as well use Free Pascal and Lazarus as they have just ported ZeosDbo
see
"Tony Caduto" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> In a real application that uses a client/server type database you should
> NEVER construct queries that return a million rows.
> You have to keep in mind that each record has to be sent accross the wire
> via TCP/IP and
On Mon, Apr 25, 2005 at 10:44:14AM -0500, John Browne wrote:
>
> Yeah, I know about pg_dump. I just was curious if there was another
> way, since I always have two psql consoles already open at all times
> anyway. :-)
You could do "\!pg_dump ..."
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---
John Browne <[EMAIL PROTECTED]> writes:
> I was curious if there was a way to get the DDL for a particular table
> from the psql client console?
No. Try
pg_dump -s -t tablename dbname
regards, tom lane
---(end of broadcast)
On Mon, Apr 25, 2005 at 11:04:27AM -0400, Alex Turner wrote:
> I have found that even the larger hosting companies such as Rackspace
> are pretty clueless when trying to configure even a mid size database
> server. They gave us a 4 drive raid 5 even after being explicitly
> asked for a RAID 10. T
On Mon, 2005-04-25 at 10:29, John Browne wrote:
> Hello,
>
> I was curious if there was a way to get the DDL for a particular table
> from the psql client console? I have two postgres boxes (development
> and production) and would like to copy & paste the DDL "CREATE TABLE"
> statements from the
Yeah, I know about pg_dump. I just was curious if there was another
way, since I always have two psql consoles already open at all times
anyway. :-)
On 4/25/05, John Browne <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I was curious if there was a way to get the DDL for a particular table
> from the p
Any reason not to use pg_dump -s?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Apr 25, 2005, at 10:29 AM, John Browne wrote:
Hello,
I w
Michael Fuhr <[EMAIL PROTECTED]> writes:
> The problem I was discussing involves getting *different* time zone
> specifictions in the output. That is, something like this (which
> apparently is possible in 7.1.3 but not in later versions):
>f | timezone
Hi,
The first time I install postgresql in Windows XP, I install it as
service. The installer asked me to create postgres account. Ok, fine...
then someday I uninstalled postgresql so I can install the newer version
of postgresql. But first to make it clean, I delete the postgres account
from righ
"Scott Ribe" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>> ..so the only question is:
>>
>> drop the the serials as PKs and just use short text handles? our
>> database size is arround 290 mb. there shouldn't be speed issues as long
>> as proper indexes exit, right? some of the co
Hello,
I was curious if there was a way to get the DDL for a particular table
from the psql client console? I have two postgres boxes (development
and production) and would like to copy & paste the DDL "CREATE TABLE"
statements from the development console to the production console when
I'm movin
> > > select f, f::timestamp at time zone 'MEZ' from test;
> > > f | timezone
> > > ---+
> > >2005-04-24 22:25:51.669218+00 | 2005-04-24 23:25:51.669218
> > > (1 row)
> >
> > Huh ? Th
"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> During a batch load of records (using COPY) I got the following
> postgres error today "tuple concurrently updated".
I don't think plain COPY could have produced that, since it only inserts
tuples. Tell us about triggers and foreign keys on this ta
I am looking at options for a customer with an installed base of ~5000 Sun
workstations running 400-500MHz UltraSPARCs. They're not getting the
performance they need. They shipped me two Tadpole Bullfrog machines, a
Bullfrog I and a Bullfrog II for evaluation.
http://www.tadpole.com
1.28GHz sin
I have found that even the larger hosting companies such as Rackspace
are pretty clueless when trying to configure even a mid size database
server. They gave us a 4 drive raid 5 even after being explicitly
asked for a RAID 10. They also put the controller in write through
cache mode. Pretty bad c
David Fetter wrote:
== PostgreSQL Product News ==
OpenRPT is a graphical SQL report writer, designer and rendering
engine, optimized for PostgreSQL. WYSIWYG display, GUI built with Qt,
runs on Linux, Windows, Mac OS X. Server-side rendering engine.
Reports can be saved as XML, either as files or in
> On Sun, 2005-04-24 at 00:53, Ron Mayer wrote:
> > Tatsuo Ishii wrote:
> > >>
> > >>Is there anyway to load balance selects to more than 2 servers? ex. 1
> > >>master with 2 slaves? Run multiple instances?
> > >
> > > It's on my TODO but will not be a trivial change.
> >
> > Could I set up 2
Thanks.
Is it on your todo list to something like this…? It is the
opposite of "/* NO LOAD BALANCE */".
Make a "/* SLAVE */" type comment to force it to a slave? It
would be helpful in forcing a query to a reporting server if you know your what
your reporting queries are.
“Set
On Sun, 2005-04-24 at 00:53, Ron Mayer wrote:
> Tatsuo Ishii wrote:
> >>
> >>Is there anyway to load balance selects to more than 2 servers? ex. 1
> >>master with 2 slaves? Run multiple instances?
> >
> > It's on my TODO but will not be a trivial change.
>
> Could I set up 2 pairs of pgpool-ba
On Mon, Apr 25, 2005 at 09:18:16AM +0200, Stephane Bortzmeyer wrote:
> On Sun, Apr 24, 2005 at 02:53:51PM -0700, David Fetter <[EMAIL PROTECTED]>
> wrote
> > >
> > > PostgreSQL 7.4, switching to 8.0 would be difficult.
> >
> > Now is easier than later.
>
> Do you mean that PostgreSQL 8 has imm
Chris Kratz <[EMAIL PROTECTED]> writes:
> It seems the consensus on this list is that when running postgres,
> Opterons outperform Xeons by a significant margin not to mention the
> CS storms postgres seems to cause on Xeons. We are looking for a
> hosting service for a postgresql based applicati
http://www.microsoft.com/downloads/details.aspx?FamilyID=4b6140f9-2d36-4977-8fa1-6f8a0f5dca8f&DisplayLang=en
On Mon, 2005-04-25 at 15:37 +0530, K.RajaSekar wrote:
> Hi
>
> I am trying to install the 8.0.2 version in windows 2000 server. After
> opening the installer, I have got the welcome scree
On Mon, Apr 25, 2005 at 08:28:47AM +0200, Karsten Hilbert wrote:
> > > gnumed=> create teable test (f timestamp with time zone);
> > > CREATE
> >
> > Does that really work in 7.1.3? Trying to create a "teable" fails
>
> This results from "script" logging backspaces into the log
> file instead of
It seems the consensus on this list is that when running postgres, Opterons
outperform Xeons by a significant margin not to mention the CS storms
postgres seems to cause on Xeons. We are looking for a hosting service for a
postgresql based application. Unfortunately, it seems most services
st
Jim C. Nasby wrote on 25/04/2005 01:28:
On Sat, Apr 23, 2005 at 10:39:14PM +, Patrick TJ McPhee wrote:
In article <[EMAIL PROTECTED]>,
Rob Kirkbride <[EMAIL PROTECTED]> wrote:
% I've done a explain analyze and as I expected the database has to check
% every row in each of the three tables b
On Monday 25 April 2005 10:54, you wrote:
> On Mon, 2005-04-25 at 03:38 +0530, Rajiv Verma wrote:
> > I'm accessing postgres database through tomcat 4.3.1.
> > I'm able to execute the select and update query through my application
> > but Insert query is giving following SQLException :
> > Connecti
Hi
I am trying to install the 8.0.2 version in windows 2000 server. After
opening the installer, I have got the welcome screen. I have selected the
Language English/English in the welcome screen and clicked the start button.
I am getting the following error.
"There is a problem with this windows
How to determinate column size in query in libpq? Especially when column
is declared for exapmle as varchar(64). PQfsize return -1 which mean
that is variable and PQfmod returns 68.
Piotr Filipczuk
---(end of broadcast)---
TIP 4: Don't 'kill -9' t
On Mon, 2005-04-25 at 03:38 +0530, Rajiv Verma wrote:
> I'm accessing postgres database through tomcat 4.3.1.
> I'm able to execute the select and update query through my application
> but Insert query is giving following SQLException :
> Connection is closed. Operation is not permitted.
looks li
Hi
During a batch load of records (using COPY) I got the following
postgres error today "tuple concurrently updated".
What could have caused this?
The only two occurences of the message in the source is in
the functions simple_head_delete and simple_heap_update
in src/backend/access/heap/heapam.c
g
ElayaRaja S schrieb:
> Hi,
>I am using Redhat Linux 9 and PostgreSQL 7.4.5. While shutdown the
> linux server i forget to stop the postgresql. After starting the linux
> server, now i am unable to stop the postgres. When stopping the
> postgres i am getting the following error as
>
> bash-2.0
On Mon, Apr 25, 2005 at 03:05:12AM -0400, Tom Lane wrote:
> > The fact that different versions of PostgreSQL get it right or
> > wrong in a variety of ways indicates that the logic may need
> > to be fixed but does show that in principle it is quite
> > possible.
>
> 7.1's version of AT TIME ZONE
On Sun, Apr 24, 2005 at 10:05:53PM -0600,
Michael Fuhr <[EMAIL PROTECTED]> wrote
a message of 85 lines which said:
> CREATE FUNCTION check_immutable() RETURNS trigger AS '
> for col in TD["args"]:
Ah, yes, much better than mine. Thanks.
---(end of broadcast)--
On Sun, Apr 24, 2005 at 02:53:51PM -0700,
David Fetter <[EMAIL PROTECTED]> wrote
a message of 21 lines which said:
> > PostgreSQL 7.4, switching to 8.0 would be difficult.
>
> Now is easier than later.
Do you mean that PostgreSQL 8 has immutable attributes ? I do not find
that.
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> The fact that different versions of PostgreSQL get it right or
> wrong in a variety of ways indicates that the logic may need
> to be fixed but does show that in principle it is quite
> possible.
7.1's version of AT TIME ZONE was so badly broken that i
73 matches
Mail list logo
