On Sat, Oct 25, 2003 at 11:04:00PM -0700, James Moe wrote:
> Other posts have noted that SCSI never fails under this condition. Apparently SCSI
> drives sense an impending power loss and flush the cache before power completely
> disappears. Speed *and* reliability. Hm.
I understood it differen
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 26 Oct 2003 16:24:17 +1300, Mark Kirkwood wrote:
>I would conclude that it not *always* the case that power failure
>renders the database unuseable.
>
>I have just noticed a similar posting from Scott were he finds the cache
>enabled case ha
Bruce Momjian wrote:
> Sean Chittenden wrote:
> > > I don't think that really answers my concern, since the sort of
> > > folks who are likely to get confused by not being able to see
> > > something that should be there are exactly the same ones who are not
> > > likely to have turned on a non-def
Got to going this today, after a small delay due to the arrival of new
disks,
So the system is 2x700Mhz PIII, 512 Mb, Promise TX2000, 2x40G ATA-133
Maxtor Diamond+8 .
The relevent software is Freebsd 4.8 and Postgresql 7.4 Beta 2.
Two runs of 'pgbench -c 50 -t 100 -s 10 bench' with a power
On Friday, October 24, 2003, at 10:19 AM, Adam Witney wrote:
I don't know what this error is particularly, but just to say that
7.4beta5
compiles and starts up fine on my OSX 10.2.8 machine
OK, I compiled beta 5 and put my rest SHMMAX back to the default
settings as provided by OS X. Still the s
In addition to all of the fancy tools, there is the
simple options on psql:
psql -H -c "select * from pg_user;";
This outputs the selections in HTML which I am
not including here. If you also use the -T
option you can set the table attributes.
--elein
[EMAIL PROTECTED]
=
running - (PostgreSQL) 7.1.3
I have loaded a table with stock market data.
-
-
-
ZRAN|2003-09-29|20030929| 731487| 20.81| 20.
ZRAN|2003-09-30|20030930| 731488| 19.43| 20.1
ZRAN|2003-10-01|20031001| 731489| 19.82| 19.9
ZRAN|2003
is it possible that there are spaces on the end? what type is
stck_sym? if it's varchar or text the padding won't be removed
automatically.
example:
basement=# create table test (t varchar(6));
CREATE TABLE
basement=# INSERT into test values( 'ZRAN ');
INSERT 92249850 1
basement=# select *
Are the fields you are usiong varchar or char.
If they are char fields they will be getting padded if you do not have the
exact amount in the field. i.e.
char(5)
da will be padded da and 0s on the end up to the sizeof the char field.
If varchar then you will be ok.
If you do have a char then
On Tue, Oct 21, 2003 at 11:42:50 +0200,
Ben-Nes Michael <[EMAIL PROTECTED]> wrote:
> what about mirroring only ? raid 1 ?
>
> I always thought that raid 1 is the fastest, am I true ?
If you have more than two disks than mirroring plus striping can be faster.
---(end of
Here's the basic issue: PostgreSQL doesn't use indexes unless a query criterion is of exactly the same type as the index type. This occurs even when a cast would enable the use of an index and greatly improve performance. I understand that casting is needed to use an index and will therefore af
On Fri, Oct 24, 2003 at 04:27:16PM -0700, [EMAIL PROTECTED] wrote:
...
> ZRAN|2003-10-03|20031003| 731491| 20.25| 21.
> (609398 rows)
> pma=> select * from stck_dta_tbl_oprtnl where stck_sym = 'ZRAN';
How about
pma=> select * from stck_dta_tbl_oprtnl where stck_sym like 'ZR
On Fri, 24 Oct 2003, scott.marlowe wrote:
> On Fri, 24 Oct 2003, Scott Chapman wrote:
[...]
> > I also love the indentation to
> > differentiate code blocks rather than the junk I'd been used to seeing in
> > Perl and previous languages.
>
> Sorry, that was the one big turnoff for me in Python.
Karen & Manfred, I can get this to work if I set it up when I create new
tables, but I need to change an existing database and it doesn't work
(perhaps a BUG?). When I try the following with my current database I
get an error:
giibdb=# ALTER TABLE project ADD CONSTRAINT company_is_ta FOREIG
This has been discussed on the XFS list. Basically, IIRC, you have to get a
drive tool like OnTrak, attach the drive via the IDE controller, disable the
cache, then reconnect it to the 3-ware controller (which does not include an
option to disable write caching; pester 3ware).
>-Original Mes
Question? Why are you restarting the postmaster? If you're getting a lot of
PIDs that means you have a lot of connections open. What are you doing to
use so many connections? Did you increase the max_connections variable?
Please supply more details of your actual problem. Perhaps a 'ps aux'
output
I have this notorious problem: at some point pgsql simply hangs up and
requires a restart.
---
---
homer:/usr/share/doc/postgresql-contrib# /etc/init.d/postgresql restart
Restarting PostgreSQL database: postmaster
Stopped
Hi Everyone,
I'm on just about all the postgres lists, except the advocacy one... I'm
not sure if this has been posted before, but this story has an amusing
quote:
MySQL is also upsetting the entire database market. Charles Garry, an
analyst at Meta Group, hails it as "a disruptive technology" t
Hi,
This will might be helpful to somebody.
www.etooss.com
Thank you
19 matches
Mail list logo
