In article <[EMAIL PROTECTED]>,
Mischa <[EMAIL PROTECTED]> writes:
> This thread seems to be focusing in on COPY efficiency,
> I'd like to ask something I got no answer to, a few months ago.
> Using COPY ... FROM STDIN via the Perl DBI (DBD::Pg) interface,
> I accidentally strung together several
In article <[EMAIL PROTECTED]>,
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> On Fri, 6 May 2005, Jim C. Nasby wrote:
>> Has thought been given to supporting inserting multiple rows in a single
>> insert? DB2 supported:
>>
>> INSERT INTO table VALUES(
>> (1,2,3),
>> (4,5,6),
>> (7,8,9)
>> );
>>
In article <[EMAIL PROTECTED]>,
Dan Harris <[EMAIL PROTECTED]> writes:
> On May 8, 2005, at 8:06 PM, Josh Berkus wrote:
>>
>>> If I were to use tsearch2 for full-text indexing, would I need to
>>> create another table that merges all of my recordtext rows into a
>>> single 'text' field type?
>>
In article
,
sverha...@wps-nl.com writes:
> SELECT * FROM events_events LEFT OUTER JOIN events_event_types ON
> eventType_id=
> events_event_types.id WHERE severity=70 AND (eventType_id IN (71)) ORDER BY
> datetime DESC LIMIT 50;
> Now I have at least two possibilities:
> - Implementing the dummy
In article <4ce2688b.2050...@tweakers.net>,
Arjen van der Meijden writes:
> On 16-11-2010 11:50, Louis-David Mitterrand wrote:
>> I have to collect lots of prices from web sites and keep track of their
>> changes. What is the best option?
>>
>> 1) one 'price' row per price change:
>>
>> create
In article <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> writes:
> Hi All,
> I am using Linux 7.2 and postgresql 7.2.
> Our Office hours are over at 6pm but we use to keep our server
> running 24 hours a day. On the second day morning, Our PGSQL
> Server becomes very slow.
> After continuous usage
In article <[EMAIL PROTECTED]>,
"Leeuw van der, Tim" <[EMAIL PROTECTED]> writes:
> So what I can say is, that if you want fast INSERT performance from
> PostgreSQL then you'll probably have to do some trickery that you
> wouldn't have to do with a default MySQL installation.
I think the word "INS
In article <[EMAIL PROTECTED]>,
Scott Kirkwood <[EMAIL PROTECTED]> writes:
> I couldn't find anything in the docs or in the mailing list on this,
> but it is something that Oracle appears to do as does MySQL.
> The idea, I believe, is to do a quick (hash) string lookup of the
> query and if it's e
In article <[EMAIL PROTECTED]>,
=?iso-8859-15?Q?Pierre-Fr=E9d=E9ric_Caillaud?= <[EMAIL PROTECTED]> writes:
> disclaimer : brainless proposition
> (SELECT * FROM table WHERE (icount(ids) <= 1 AND ids[1] = 33)
> UNION ALL
> (SELECT * FROM table WHERE (icount(ids) > 1 AND ids && '{33}'));
I g
In article <[EMAIL PROTECTED]>,
Greg Stark <[EMAIL PROTECTED]> writes:
> Christopher Browne <[EMAIL PROTECTED]> writes:
>> After all, the cost of a computer system to run the transactions is
>> likely to be comprised of some combination of software licenses and
>> hardware costs. Even if the soft
In article <[EMAIL PROTECTED]>,
=?ISO-8859-15?Q?Miroslav_=A6ulc?= <[EMAIL PROTECTED]> writes:
>> Instead of a varchar(1) containing 'y' or 'n' you could use a
>> BOOL or an integer.
> Sure I could. The problem is our project still supports both MySQL and
> PostgreSQL. We used enum('Y','N') in My
In article <[EMAIL PROTECTED]>,
Ron St-Pierre <[EMAIL PROTECTED]> writes:
>> For what it's worth NUMERIC columns take more space than you might expect.
>> Figure a minimum of 12 bytes your rows are at about 1.5k each even if the
>> non-numeric columns aren't large themselves. What are the other co
Tom Lane writes:
> No surprise, see AsyncExistsPendingNotify. You would have a lot of other
> performance issues with sending hundreds of thousands of distinct notify
> events from one transaction anyway, so I can't get terribly excited about
> this.
@Filip: you probably want a per-statement tr
13 matches
Mail list logo