I am looking at the explain data for my query and it mostly
understandable thanks to an excellent article by Jim Nasby,
http://www.pervasive-postgres.com/instantkb13/article.aspx?id=10120
It is very time consuming and confusing walking through the explain. Is
there a possibility (or does it ev
[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 recentl
[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 Sonda
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
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 what
* 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 non
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 pa
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 high
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
Sim Zacks wrote:
I disagree with you that a human brain would be better then a machine
for optimizing purposes. If the system is programmed to optimize
correctly, then it will when to stick data into a temp table and update
columns instead of doing a select because x number of joins are too muc
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 t
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 h
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
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
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 usu
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
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?
thanks
---(end of broadcast)--
"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 s
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 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
get an error m
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 broadcast)-
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 can’t remember/find it anymore. Do you know if it’s
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 group
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 broadcast)---
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 more
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"
Sent: Wednesday, May 10, 2006 12:30 P
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 PR
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 attemptin
"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 nu
[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 imag
While running the recovery process I am getting the following errors for cannot stat:
cp: cannot stat `/data1_node5/arch/0001.history': No such file or
directory
cp: cannot stat
`/data1_node5/arch/00010007.02C4C530.backup': No such
file or directory
cp: cannot stat `/data1_node5
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 -
38 matches
Mail list logo
