On 07/06/10 10:29, John T. Dow wrote:
> One of my clients is getting this problem occasionally. Actually, we
> can cause it to happen quite reliably by pasting certain text into a
> couple of fields, but the vast majority of text entered into the vast
> majority of fields causes no problem.
> I've
On 07/06/10 08:34, Zery wrote:
> All,
>
>
> I'm a newbie in postgresql, a few days ago i install postgresql
> 8.4.3.1 and it works fine, yesterday i install cyberlink powerdvd 9
> and after that my postgresql server cannot start, it give the
> following error info :
>
> " The postgresql-8.4 - Po
I have a set of results that I am selecting from a set of tables which I
want to return in a random weighted order for each priority group returned.
Each row has a priority column and a weight column. I sort by the priority
column with 1 being highest priority. Then, for each distinct priority, I
w
One of my clients is getting this problem occasionally. Actually, we can cause
it to happen quite reliably by pasting certain text into a couple of fields,
but the vast majority of text entered into the vast majority of fields causes
no problem.
I've read enough to suggest that AV software migh
All,
I'm a newbie in postgresql, a few days ago i install postgresql
8.4.3.1 and it works fine, yesterday i install cyberlink powerdvd 9
and after that my postgresql server cannot start, it give the
following error info :
" The postgresql-8.4 - PostgreSQL Server 8.4 service is starting
The
Wang, Mary Y wrote:
Hi,
I'm using a psql -f command to reload the data from a dump file. I noticed that some
tables are not populated with any rows (I mean 0 rows), yet, if I manually insert a row
(actually just copy an INSERT statement from that input file) in the interactive
terminal, that
Hi,
I'm using a psql -f command to reload the data from a dump file. I noticed
that some tables are not populated with any rows (I mean 0 rows), yet, if I
manually insert a row (actually just copy an INSERT statement from that input
file) in the interactive terminal, that row was added with no
Thank you all for your explaination.
--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com
Cheap and Reliable VPS Hosting: http://j.mp/arHk5e
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
On Sun, Jun 06, 2010 at 10:15:52AM -0500, Little, Douglas wrote:
> They should generate equivalent results,
> But the difference is the constraint on bu.bid=5.
> In the 1st case it's being done after the join.
> In the 2nd case it is being done before the join.
In PG version 8.1 (?) and onward
Nilesh,
They should generate equivalent results,
But the difference is the constraint on bu.bid=5.
In the 1st case it's being done after the join.
In the 2nd case it is being done before the join.
The end result should be the same, but the execution time can be hugely
different.
Suppose b ha
On 06/06/2010 02:04 AM, Greg Smith wrote:
u235sentinel wrote:
A Dell system running a PERC with battery-backed write controller will
be faster on database writes than your 4540. Those Sun boxes are
terrible at OLTP style workloads in particular, the types of writes
PostgreSQL does can't be c
On 06/05/2010 07:20 PM, John R Pierce wrote:
My manager and I are looking at replacing a Sun x4540 server with a
Dell server connected to a disk subsystem (or two). We're looking at
the R710 servers connected to an MD1220 I believe (I'd have to look
again at the quote).
why are you looki
On 6 June 2010 06:30, Nilesh Govindarajan wrote:
> 1. SELECT b.* from banners b, banners_users bu where b.id = bu.bid and
> bu.uid = 5;
>
> 2. SELECT b.* from banners b INNER JOIN banners_users bu ON b.id =
> bu.bid AND bu.uid = 5;
Here is an explanation:
http://www.postgresql.org/docs/8.4/intera
u235sentinel wrote:
The concern we have is our 4540 has a 2TB database which is working
great. The server has 48 hard drives (250 gig drives) in RAID 10
across 6 disk controllers. A couple HBA controllers connected to a
couple dozen disks may be slower (though dell assures us it will be
fast
14 matches
Mail list logo
