2b- LARGE UPS because HDs are the components that have the higher power
consomption (a 700VA UPS gives me about 10-12 minutes on a machine
with a XP2200+, 1GB RAM and a 40GB HD, however this fall to..
less than 25 secondes with seven HDs ! all ATA),
I got my hands on a (free)
[EMAIL PROTECTED] wrote:
A word of advice: if there is any chance that a column (e.g. text) contains
an embedded newline, you will be much better off outputting the data in
simple xml, instead of CSV. This works very well with Excel for import. I
just did a simple program for this recently.
[Don't forget to CC the list so everyone can see your reply]
The pgInstaller uses Wix which is open source. You can download it
from Source Forge.
John
On May 10, 2006, at 7:23 AM, Thomas Sondag wrote:
2006/5/10, John DeSoi [EMAIL PROTECTED]:
On May 8, 2006, at 12:14 PM, Thomas Sondag
Greg Stark [EMAIL PROTECTED] writes:
Douglas McNaught [EMAIL PROTECTED] writes:
Correct me if I'm wrong, but I've never heard of a 15kRPM SATA drive.
Well, dollar for dollar you would get the best performance from slower drives
anyways since it would give you more spindles. 15kRPM drives
Sim Zacks wrote:
Something such as: with this explain data, adding an index on table tbl
column A would drastically improve the efficiency. Or at least an
application that would say, the least efficient part of your query is on
this part of the code so that you could more easily figure out
* Hannes Dorbath:
+ Hardware Raids might be a bit easier to manage, if you never spend a
few hours to learn Software Raid Tools.
I disagree. RAID management is complicated, and once there is a disk
failure, all kinds of oddities can occur which can make it quite a
challenge to get back a
On 5/10/06, Alban Hertroys [EMAIL PROTECTED] wrote:
Sim Zacks wrote:
Something such as: with this explain data, adding an index on table tbl
column A would drastically improve the efficiency. Or at least an
application that would say, the least efficient part of your query is on
this part of
Hello,
I wrote the UDT input/output functions for my complex type
and everything is working well.
But now, in the input function, I need to get the relation/attribute
names where a new object is being inserted.
PG_FUNCTION_INFO_V1(complex_in);
Datum complex_in(PG_FUNCTION_ARGS) {
char *arg1 =
I agree with you that an index isn't always the answer, that was more of
an example. I was thinking more along the lines of an intelligent part
of the database that has access to the statistics and would be able to
spit out recommendations for the query.
Such as, I type in a monster query and
Hi, Scott all,
Scott Lamb wrote:
I don't know the answer to this question, but have you seen this tool?
http://brad.livejournal.com/2116715.html
We had a simpler tool inhouse, which wrote a file byte-for-byte, and
called fsync() after every byte.
If the number of fsyncs/min is higher
Markus Schaber wrote:
Hi, Scott all,
Scott Lamb wrote:
I don't know the answer to this question, but have you seen this tool?
http://brad.livejournal.com/2116715.html
We had a simpler tool inhouse, which wrote a file byte-for-byte, and
called fsync() after every byte.
If
On Wed, May 10, 2006 at 09:58:04AM -0300, Humberto Luiz Razente wrote:
I wrote the UDT input/output functions for my complex type
and everything is working well.
But now, in the input function, I need to get the relation/attribute
names where a new object is being inserted.
Why would the
Hi, Bruce,
Bruce Momjian wrote:
It does not find as much liers as the script above, but it is less
Why does it find fewer liers?
It won't find liers that have a small lie-queue-length so their
internal buffers get full so they have to block. After a small burst at
start which usually hides
On Tue, 2006-05-09 at 20:02, Bruce Momjian wrote:
Scott Marlowe wrote:
Actually, in the case of the Escalades at least, the answer is yes.
Last year (maybe a bit more) someone was testing an IDE escalade
controller with drives that were known to lie, and it passed the power
plug pull
Scott Marlowe [EMAIL PROTECTED] writes:
On Tue, 2006-05-09 at 20:02, Bruce Momjian wrote:
You do if the controller thinks the data is already on the drives and
removes it from its cache.
Bruce, re-read what I wrote. The escalades tell the drives to TURN OFF
THEIR OWN CACHE.
Some ATA
Hi, Bruce,
Markus Schaber wrote:
It does not find as much liers as the script above, but it is less
Why does it find fewer liers?
It won't find liers that have a small lie-queue-length so their
internal buffers get full so they have to block. After a small burst at
start which usually hides
On Wed, 2006-05-10 at 09:51, Douglas McNaught wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
On Tue, 2006-05-09 at 20:02, Bruce Momjian wrote:
You do if the controller thinks the data is already on the drives and
removes it from its cache.
Bruce, re-read what I wrote. The escalades
Humberto Luiz Razente [EMAIL PROTECTED] writes:
I wrote the UDT input/output functions for my complex type
and everything is working well.
But now, in the input function, I need to get the relation/attribute
names where a new object is being inserted.
Since, in general, there *is* no such
On Wed, 2006-05-10 at 10:12, [EMAIL PROTECTED] wrote:
sorry for sending this message out in the list... but there is no explanation
anywhere about how to unsuscribe this list.
the link to subscribe/unsubscribe takes me to pgfoundry.
can anybody give me a hint on how to unsubscribe?
The folkson the Delphi forum haven't been responsive
to this question. Perhaps the ones that visit the forum don't know the
answer.
I have created a Delphiinterface to a Postgresql
tablecontaining a serial column.
When I try to insert a new value through the interface I
get an error
On Tue, May 09, 2006 at 22:17:21 +0300,
Joe Kramer [EMAIL PROTECTED] wrote:
Right on! SHA2 should fallback the same as AES!
Note that it's SHA256, not SHA2.
SHA-1 is really a fix of the original SHA (sometimes referred to as SHA-0).
---(end of
Bob Pawley wrote:
The folks on the Delphi forum haven't been responsive to this question.
Perhaps the ones that visit the forum don't know the answer.
I have created a Delphi interface to a Postgresql table containing a
serial column.
When I try to insert a new value through the interface I
Sometime ago I saw a project with the purpose of creating Oracle
views over the PostgreSQL catalog.
I cant remember/find it anymore. Do you know if its
still available?
Is there any other project aiming to create friendly catalog
views?
Best Regards,
Bruno
jef peeraer wrote:
beer schreef:
Hello All
So I have an old database that is ASCII_SQL encoded. For a variety
of reasons I need to convert the database to UNICODE. I did some
googling on this but have yet to find anything that looked like a
viable option, so i thought I'd post to the
Hi all,
ive just instaled Fedora 5, with postgresql 8.1.3 on my PC, and im trying to
install POSTGIS, but when i do the
./config says that the package pg_config is missing.
Can someone help me?
PS: Sorry about the bad english.
---(end of
On 5/10/06, Bruno Wolff III [EMAIL PROTECTED] wrote:
On Tue, May 09, 2006 at 22:17:21 +0300,
Joe Kramer [EMAIL PROTECTED] wrote:
Right on! SHA2 should fallback the same as AES!
Note that it's SHA256, not SHA2.
It's SHA224/256/384/512, which together are more easily referred as SHA2.
Bob,
Can you at least show what your insert statement looks like please?
Also, are you using ODBC or VitaVoom's direct driver for DBExpress?
Frank
Bob Pawley wrote:
The folks on the Delphi forum haven't been responsive to this
question. Perhaps the ones that visit the forum don't know the
Alban Hertroys wrote:
Sim Zacks wrote:
Something such as: with this explain data, adding an index on table
tbl column A would drastically improve the efficiency. Or at least an
application that would say, the least efficient part of your query is
on this part of the code so that you could
Hi Frank
Here's the code entered as part of TUpdateSQL component.
insert into p_id.p_id
(process_name)
values
(:process_name)
I am connected via ODBC.
Thanks
Bob
- Original Message -
From: Frank L. Parks [EMAIL PROTECTED]
To: Postgresql pgsql-general@postgresql.org
Sent:
Bob Pawley wrote:
Hi Frank
Here's the code entered as part of TUpdateSQL component.
insert into p_id.p_id
(process_name)
values
(:process_name)
Did my DEFAULT not work?
Joshua D. Drake
I am connected via ODBC.
Thanks
Bob
- Original Message - From: Frank L. Parks
[EMAIL
Joshua
My first try was to include it with the SQL code on the Update component.
It hasn't worked yet. I want to try variations.
I am also trying a Query component which gave me the same error. I also have
another problem with this component giving me a cursor handle error which I
am
ftoliveira [EMAIL PROTECTED] writes:
ive just instaled Fedora 5, with postgresql 8.1.3 on my PC, and im trying to
install POSTGIS, but when i do the
./config says that the package pg_config is missing.
Did you remember to install the postgresql-devel RPM? You need that for
building any
I came across a guy that wanted to get rows from a table by specifying
the table name and column ordinal number and nothing more. [Yes, this
is useless and violates relational model and SQL priniciples.]
My initial thoughts centered on using an array to snag each row and
pull out the column
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]
On Wed, May 10, 2006 at 02:50:26PM -0300, Humberto Luiz Razente wrote:
I'm trying to index data characteristics extracted from multimedia
files (like a color distribution histogram from an
Hi.
I've been able to compile postgresql on solaris 10.
Now I want to install the perl DBD::Pg module but I get a complaint, namely:
/~~~
[EMAIL PROTECTED] # make
rm -f blib/arch/auto/DBD/Pg/Pg.so
LD_RUN_PATH=/usr/local/pgsql/lib /opt/SUNWspro/bin/cc -G
-xarch=generic64
35 matches
Mail list logo
