On Aug 29, 2007, at 5:15 AM, Jens Reufsteck wrote:
I'm having a strange performance issue with two almost similar
queries, the
one running as expected, the other one taking far more time. The only
difference is that I have "uniid in (10)" in the normally running
query and
"uniid in (9,10)" in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/07 08:12, chris smith wrote:
>> Ever read anything on how myspace is laid out? The big ones need
>> replication to handle the traffic.
>
> Actually no.
>
> http://highscalability.com/livejournal-architecture
>
> "Using MySQL replication on
On Saturday 01 September 2007 12:16 am, Ashish Karalkar wrote:
> Hello All,
> I want to export data from PostgreSQL tables to MS Excel.
> Is there any way?
>
> Thanks in advance...
>
> With Regrads
> Ashish...
One relatively easy way to do it is to use the Base component of OpenOffice.
You can dum
=?ISO-8859-1?Q?Norberto_Dell=EA?= <[EMAIL PROTECTED]> writes:
> I have a PostgreSQL 8.2.4 installation running under Windows XP with WAL
> archiving activated.
> But at some point Postgres began to ask to archive a WAL segment that
> isn't in the pg_xlog directory. I thought that a segment that isn
Alban Hertroys <[EMAIL PROTECTED]> writes:
> I am kind of surprised that the planner doesn't understand that a
> foreign key with a unique constraint (which a primary key is) means
> there is a 0..1 to 1 relationship with the target table.
Hm? It correctly estimated that it'd get one row out
On Sep 1, 2007, at 14:44, Martijn van Oosterhout wrote:
On Sat, Sep 01, 2007 at 02:24:25PM +0200, Alban Hertroys wrote:
Oh, now I see... The first time guarantees that v has a value (as
random() < 1/1), and after that there is a decreasing chance that a
new row gets re-assigned to v. That means
--- Ashish Karalkar <[EMAIL PROTECTED]> wrote:
> Hello All,
> I want to export data from PostgreSQL tables to MS Excel.
> Is there any way?
Excel has the ability to directly pull data from any system ODBC DSN configured
on the windows
box. Was is nice with this method is the ability for the use
"Phoenix Kiula" <[EMAIL PROTECTED]> writes:
> On 01/09/07, Alban Hertroys <[EMAIL PROTECTED]> wrote:
>> Is 10 ms problematic for this query?
> I think you got 10ms from the query plan? These queries are very fast
> after they have been executed once. But the first time is huge.
> Sometimes I have
On Sep 1, 2007, at 14:48, Phoenix Kiula wrote:
On 01/09/07, Alban Hertroys <[EMAIL PROTECTED]> wrote:
On Sep 1, 2007, at 11:46, Phoenix Kiula wrote:
.
..snip
However, there's a nested loop in there as the EXPLAIN ANALYZE shows
below. What is causing this nested loop?
It looks like it
Greetings to everyone
I have a PostgreSQL 8.2.4 installation running under Windows XP with WAL
archiving activated.
But at some point Postgres began to ask to archive a WAL segment that
isn't in the pg_xlog directory. I thought that a segment that isn't
succesfully
archived should remain in the
"Anthony Brock (KG4AGD)" <[EMAIL PROTECTED]> writes:
> I am getting an error trying to connect to PostgreSQL db using Visual
> Basic.NET 2005. The error message is "FATAL: invalid command-line
> arguments for server process. HINT: Try "postgres --help" for more
> information."
This implies inco
"chris smith" <[EMAIL PROTECTED]> wrote:
>
> > Ever read anything on how myspace is laid out? The big ones need
> > replication to handle the traffic.
>
> Actually no.
>
> http://highscalability.com/livejournal-architecture
>
> "Using MySQL replication only takes you so far." (Yeh it's mysql bu
For quick/simple table format reports, you can just use psql to create
the output in HTML format, then import that directly into Excel. For
example, I use the following psql line to generate an HTML-format report
of server IP information; this file can then be directly opened in
Excel. (Excel 200
> Ever read anything on how myspace is laid out? The big ones need
> replication to handle the traffic.
Actually no.
http://highscalability.com/livejournal-architecture
"Using MySQL replication only takes you so far." (Yeh it's mysql but
the point is valid regardless).
"You can't keep adding re
I am getting an error trying to connect to PostgreSQL db using Visual
Basic.NET 2005. The error message is "FATAL: invalid command-line
arguments for server process. HINT: Try "postgres --help" for more
information."
Here is a the snippet of code to create connection. Looking for
suggestions
On 01/09/07, Alban Hertroys <[EMAIL PROTECTED]> wrote:
>
> On Sep 1, 2007, at 11:46, Phoenix Kiula wrote:
.
..snip
> > However, there's a nested loop in there as the EXPLAIN ANALYZE shows
> > below. What is causing this nested loop?
>
> It looks like it's used to match trades to tradecounts. I
On Sat, Sep 01, 2007 at 02:24:25PM +0200, Alban Hertroys wrote:
> Oh, now I see... The first time guarantees that v has a value (as
> random() < 1/1), and after that there is a decreasing chance that a
> new row gets re-assigned to v. That means the last row has a chance
> of 1/n, which would
On Sep 1, 2007, at 12:44, Alban Hertroys wrote:
It would be possible to write an aggregate that returns a single
random
value from a set. The algorithm is something like:
n = 1
v = null
for each row
if random() < 1/n:
v = value of row
n = n + 1
return v
Doesn't this always return
Markus Schiltknecht <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Bill Moran wrote:
> > While true, I feel those applications are the exception, not the rule.
> > Most DBs these days are the blogs and the image galleries, etc. And
> > those don't need or want the overhead associated with synchronous
> >
On Sep 1, 2007, at 11:46, Phoenix Kiula wrote:
Hello,
I have a simple query as follows. It joins two very straightforward
tables.
SELECT
trades.id,
trades.url,
trades.alias,
tradecount.t_count,
tradecount.u_count
FROM trades
LEFT JOIN tradecount ON trades.id = tradecount.id
WHER
On Aug 31, 2007, at 15:54, Martijn van Oosterhout wrote:
On Fri, Aug 31, 2007 at 02:42:18PM +0200, Alban Hertroys wrote:
Examples:
* random(maxrows) would return random rows from the resultset.
* median() would return the rows in the middle of the result set
(this
would require ordering to b
Ashish Karalkar wrote:
> Hello All,
> I want to export data from PostgreSQL tables to MS Excel.
> Is there any way?
ODBC is one way to do it.
Use the data import, that runs msquery
--
/Björn
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 9: In ve
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/01/07 02:16, Ashish Karalkar wrote:
> Hello All,
> I want to export data from PostgreSQL tables to MS Excel.
> Is there any way?
Extract the data to a CSV (comma or tab) file.
http://www.postgresql.org/docs/
http://www.postgresql.org/docs/8.2/i
Hello,
I have a simple query as follows. It joins two very straightforward tables.
SELECT
trades.id,
trades.url,
trades.alias,
tradecount.t_count,
tradecount.u_count
FROM trades
LEFT JOIN tradecount ON trades.id = tradecount.id
WHERE trades.user_id = 'jondoe' and trades.status = 'Y'
OR
On 01/09/07, Ashish Karalkar <[EMAIL PROTECTED]> wrote:
>
>
> Hello All,
> I want to export data from PostgreSQL tables to MS Excel.
> Is there any way?
Sure, write SQL in a program (php, perl, jsp, asp) to dump the tables
in HTML rows format. Then import that HTML page
program into Excel from
Hello All,
I want to export data from PostgreSQL tables to MS Excel.
Is there any way?
Thanks in advance...
With Regrads
Ashish...
26 matches
Mail list logo
