On 3/26/06, Ed L. <[EMAIL PROTECTED]> wrote:
> On Saturday March 25 2006 9:36 pm, Ed L. wrote:
> > I have a performance riddle, hoping someone can point me in a
> > helpful direction. We have a pg 8.1.2 cluster using
> > Apache::Sessions and experiencing simple UPDATEs taking
> > sometimes 30+ sec
On Saturday March 25 2006 9:49 pm, Ed L. wrote:
> On Saturday March 25 2006 9:36 pm, Ed L. wrote:
> > I have a performance riddle, hoping someone can point me in
> > a helpful direction. We have a pg 8.1.2 cluster using
> > Apache::Sessions and experiencing simple UPDATEs taking
> > sometimes 30+
On Saturday March 25 2006 9:36 pm, Ed L. wrote:
> I have a performance riddle, hoping someone can point me in a
> helpful direction. We have a pg 8.1.2 cluster using
> Apache::Sessions and experiencing simple UPDATEs taking
> sometimes 30+ seconds to do a very simply update, no foreign
> keys, no
I have a performance riddle, hoping someone can point me in a
helpful direction. We have a pg 8.1.2 cluster using
Apache::Sessions and experiencing simple UPDATEs taking
sometimes 30+ seconds to do a very simply update, no foreign
keys, no triggers:
Table "public.sessions"
Column
> Hrm ok ill see about doing either the patch or setting wal_debug to
> true (or both). However im currently on vacation till Saturday so ill
> do this first thing then and report the results back. Thank you very
> much!
Ok here is the output with wal_debug set to 1 in the config and the
final
On 03/24/2006 10:07:24 PM, Tom Lane wrote:
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> The Makefile has
Does it work better if you change that to
[ -x /usr/bin/chcon ] && /usr/bin/chcon -u user_u -r object_r -t
postgresql_db_t testtablespace results
Nope. The other thing to keep in mind
After exchanging a few emails regarding pgbench in the list, I was
thinking it'll be cool to have a place to post pgbench resulats from
all over the place. Just so people can get an idea of what others are
getting.
If more people think it's a good idea, I'll be glad to host it as part
of my blog.
Hi,
We currently have 28 bloggers in Planet PostgreSQL
(http://PlanetPostgreSQL.org ), and we hope to grow more.
For the people who want to blog on PostgreSQL, but does not have a
blogging area, we provide a space: http://people.PlanetPostgreSQL.org .
If you think you are interested, please dro
Hello!
First tried some searching around, but did not find anything useful so I gave up and decided to ask here... I am
wondering how do pair of 1.5GHz Itanium2(4MB cache) stack up against pair of AMD or Intel server CPUs as far as
postgresql performance is concerned? Is it worthy or not?
Th
Leif Jensen wrote:
Hello,
I have with great interrest been following this thread. We have a
(small) flame war in house about this and I'm very happy about all the
arguments I have seen. I'm a long time user of PostgreSQL (which possibly
makes me a bit biased ;-) ) and I think it's great. I'm
On Thu, Mar 23, 2006 at 15:24:16 -0600,
Michael Lea <[EMAIL PROTECTED]> wrote:
>
> $s = $db->prepare('SELECT id FROM person WHERE lname = ? AND fname = ?');
>
> But this does not, returning an empty list:
> $s->execute('Cher', undef);
= NULL will return NULL for every row and no rows will
On Sat, Mar 25, 2006 at 14:30:54 +0100,
Leif Jensen <[EMAIL PROTECTED]> wrote:
>
> 1) I wonder that no one has mentioned anything about security issues in
> those two. I know that I'm a novice and that I didn't use MySql very much,
> but it seems to me that the PostgreSQL security is much better
am 25.03.2006, um 14:12:16 +0100 mailte Peter Eisentraut folgendes:
> Am Freitag, 24. März 2006 18:48 schrieb A. Kretschmer:
> > am 24.03.2006, um 19:13:56 + mailte Mary Adel folgendes:
> > > Is the server running on host "xxx.xxx.xxx.xxx" and accepting
> > > TCP/IP connections on port 5432?
On Fri, Mar 24, 2006 at 06:56:19PM -0500, Tom Lane wrote:
> "Just Someone" <[EMAIL PROTECTED]> writes:
> > Actually, most table are VERY small. On each schema I would expect 4 -
> > 5 tables to go over 1000 records. The rest will be much smaller, with
> > most at under 100. And aside from 2-3 table
Hello,
I have with great interrest been following this thread. We have a
(small) flame war in house about this and I'm very happy about all the
arguments I have seen. I'm a long time user of PostgreSQL (which possibly
makes me a bit biased ;-) ) and I think it's great. I'm not a big database
Am Freitag, 24. März 2006 18:48 schrieb A. Kretschmer:
> am 24.03.2006, um 19:13:56 + mailte Mary Adel folgendes:
> > Is the server running on host "xxx.xxx.xxx.xxx" and accepting
> > TCP/IP connections on port 5432?
> My guess: you should check your pg_hab.conf.
If that were the problem, th
On 3/25/06, nik600 <[EMAIL PROTECTED]> wrote:
> hi
>
> i am considering to port an important web applications to postgres,
> this applications is made of php and i reuse the same code for many
> customer, due to have a clean structure and simple updates...
>
> now i have one code and many databases
On Sat, Mar 25, 2006 at 12:06:34PM +0530, AKHILESH GUPTA wrote:
> hi all,
> below I have created two tables in pgsql with field name as 'name' and 'id'
> as their datatype 'varchar(15)' and 'integer'.
Looks like:
select * from test1
UNION ALL
select * from test3;
would be a very good start.
--
18 matches
Mail list logo
