Benjamin Krajmalnik wrote:
We are currently inserting about 1 million rows per day, and will
increase to probably 5 million once it goes into full deployment.
It is currently running on a 3GHz Xeon HT, 2GB RAM, dual 72GB disks
running RAID 1. This server is a 1U without only 2 drive bays, so
Hi,
It is currently running on a 3GHz Xeon HT, 2GB RAM, dual 72GB disks
running RAID 1. This server is a 1U without only 2 drive bays, so I
have a potential issue with drive space.
As a result, I will be moving the db server to a Dell 1650 with 3 146GB
SCSI drives running RAID 0. System is a d
Hi, I am having troubles using pg_restore : none of my indexes are restored !It did not see any relevant message in the pg_restore output to explain this behaviour.So I am trying to restore a pg_dump (version8.1
) sql dump file from a remote 8.0.3 DB into a local 8.1 DB using pg_restore (version 8.
Hi, I am having troubles using pg_restore : none of my indexes are restored !It did not see any relevant message in the pg_restore output to explain this behaviour.So I am trying to restore a pg_dump (
version8.1
) sql dump file from a remote 8.0.3 DB into a local 8.1 DB using pg_restore (version 8
-- Jorge Gabriel González B.Analista de SistemasPTI - Parque Tecnológico ITAIPU (www.pti.org.br / www.pti.org.py)Fábrica de Software
E-mail ([EMAIL PROTECTED]) ([EMAIL PROTECTED])
"David Levy" <[EMAIL PROTECTED]> writes:
> So I am trying to restore a pg_dump (version8.1 ) sql dump file from
> a remote 8.0.3 DB into a local 8.1 DB using pg_restore (version
> 8.1). Is there something incompatible The dump file seems to be
> correct regarding index creation statements I really
I am using pgAdmin and phpPgAdmin with the same results (no triggers, no indexes).Thanks but the docs were not helpful yet. I've been trying to solve the issue many times in the past few monthes before posting to the list today.
:(On 27 Apr 2006 07:45:55 -0400, Jerry Sievers <[EMAIL PROTECTED]> wro
unsubscribe-digest pgsql-admin
---(end of broadcast)---
TIP 6: explain analyze is your friend
A few days ago, someone in this
list gives me a function (plpgsql) that evaluates if a string is a
valid date or not.
It returns 1 or 0 (valid/Not Valid)
The problem is that if the argument is a NULL field
the function returns 1.
I don't have experience with plpgsql language.
This is the
Title: Re: [ADMIN] IsDate function in plpgsql
I think someone will show you a better way, but if all you need to do is account for the NULLS...
begin
if $1 is null then
return 0;
else
perform $1::date;
return 1;
end if;
exception when others then
return 0;
end
On 4/27/06
Sistemas C.M.P. wrote:
A few days ago, someone in this list gives me a function (plpgsql) that
evaluates if a string is a valid date or not.
It returns 1 or 0 (valid/Not Valid)
The problem is that if the argument is a NULL field the function returns 1.
I don't have experience with plpgsql langu
I was thinking of going Raid 0 to increase the active spindles. But,
come to think about it, if I go to FreeBSD I really do not need to go
that route, since I can use a symlink and, as suggested, move the logs
to another spindle.
I was also wary of the Raid 0 approach - specially since last year I
I have a table called type:
type
---
type_id integer
tvalue smallint
...
..
..
tvalue was a second key on this table which now turns out to be unnecessary.
Before I can remove it I need to change the columns which reference it. I
wanted to do this with
alter table alter column using
But
Assuming that presently the server's capability as far as drives is 3
drives, would you recommend doing a RAID-1 on 2 drives and an additional
non RAIDed drive to hold the WAL? Anything else which shold be moved to
the other spindle?
I would RAID-1 the WAL. Assuming you have a mechanism to
On Wed, 2006-04-26 at 20:30, Benjamin Krajmalnik wrote:
> I am about to take a system from testing into production.
>
> The system is a combination oltp/bi (network monitoring platform).
>
> We are currently inserting about 1 million rows per day, and will
> increase to probably 5 million once it
Anytime you're looking at a high write load on a database (not just
PostgreSQL) you should be looking at a hardware RAID controller with
battery backed cache and RAID 1 or RAID 1+0.
We recently benchmarked the latest and greatest PCI-X SATA mega raid
controller (with NCQ support, so approach
On Thu, 2006-04-27 at 13:43, Robin Iddon wrote:
> > Anytime you're looking at a high write load on a database (not just
> > PostgreSQL) you should be looking at a hardware RAID controller with
> > battery backed cache and RAID 1 or RAID 1+0.
> >
> We recently benchmarked the latest and greatest
[EMAIL PROTECTED] (Scott Marlowe) writes:
> Note that some folks have mentioned that Dell uses their own
> firmware on these cards, and that firmware is supposedly slower than
> the stock firmware those cards come with.
Worse, the default behaviours apparently involve "works *like* RAID10"
as oppo
Can not install by
Create language pltcl;
Or
Createlang.exe pltcl --dbname=mydb –username=me
Keep getting
ERROR: could not load library "C:/Program
Files/PostgreSQL/8.1/lib/pltcl.dll": The specified module could not be
found.
HELP
Hi
Is there a way to issue commits in long running functions.
Currently, I make calls out to java functions for transaction blocks that need
committing at frequent intervals.
The begin..end savepoint feature is nice, but what I am
looking for is a way to reduce resources/log file g
Jim C. Nasby wrote:
On Wed, Apr 26, 2006 at 07:30:49PM -0600, Benjamin Krajmalnik wrote:
I am about to take a system from testing into production.
The system is a combination oltp/bi (network monitoring platform).
We are currently inserting about 1 million rows per day, and will
increase to
Our database files are becoming bigger and bigger.
We checked OID with filenodes and found some filenodes
that don't have a corresponding OID.
Can I delete these files ? Or give me an advice, please.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has
Record insertion is done via an ODBC call to a stored procedure from a
Windows based host monitor"
I wondered what this stored procedure was (is it a function or something
outside postgresql).
There was an interesting article on odbc - that application code can make
big differences in data
dzung nguyen the <[EMAIL PROTECTED]> writes:
> Our database files are becoming bigger and bigger.
> We checked OID with filenodes and found some filenodes
> that don't have a corresponding OID.
OID? Or relfilenode? Please read
http://www.postgresql.org/docs/8.1/static/storage.html
pretty darn ca
It will be helpful if you tell us what OS you are using :)
Linux
/etc/init.d/postgres start
/etc/rc.d/postgres start
It will initialized the database @ /var/lib/pgsql/data or
/usr/local/pgsql depending on the distro.
Or do man pg_ctl or man postmaster
More Info
http://www.postgresql.org/docs/7.4/s
Can I delete these files ? Or give me an advice, please.
When I had a similar problem it turned out that I had exceeded the
limits of my FSM and thus the stats table in particular was growing as
it was unable to reuse rows.
Check your FSM size in postgresql.conf and see what:
max_fsm_p
26 matches
Mail list logo