Hello List,
As an editor for the german Linux Magazine I am looking for Authors who would
want to write an article of about 5-7 pages (=15-2 characters) on Postgres
Troubleshooting and Performance issues. The Article is planned for our
forthcoming "Linux Technical Review 09 - Datenbanken",
In response to Markus Feilner <[EMAIL PROTECTED]>:
>
> As an editor for the german Linux Magazine I am looking for Authors who would
> want to write an article of about 5-7 pages (=15-2 characters) on
> Postgres
> Troubleshooting and Performance issues. The Article is planned for our
> for
On Mon, May 19, 2008 at 11:56 PM, kevin kempter
<[EMAIL PROTECTED]> wrote:
> Hi all;
>
> I have a query that does this:
>
> update tab_x set (inactive_dt, last_update_dt) =
> ((select run_dt from current_run_date), (select run_dt from
> current_run_date))
> where
> cust_id::text || loc_id::text in
Hi all;
I have 2 tables where I basically want to delete from the first table
(seg_id_tmp7) any rows where the entire row already exists in the
second table (sl_cd_segment_dim)
I have a query that looks like this (and it's slow):
delete from seg_id_tmp7
where
customer_srcid::text
Version 8.3.1
On May 20, 2008, at 1:51 PM, kevin kempter wrote:
Hi all;
I have 2 tables where I basically want to delete from the first
table (seg_id_tmp7) any rows where the entire row already exists in
the second table (sl_cd_segment_dim)
I have a query that looks like this (and it's
On Tue, 20 May 2008 22:03:30 +0200, kevin kempter
<[EMAIL PROTECTED]> wrote:
Version 8.3.1
On May 20, 2008, at 1:51 PM, kevin kempter wrote:
Hi all;
I have 2 tables where I basically want to delete from the first table
(seg_id_tmp7) any rows where the entire row already exists in the
Hi,
I am currently designing a database and wanted to know something that may
sound trivial, but I thought its still good to confirm before dumping
millions of rows in it.
The design requires a few master tables with very limited rows, for e.g.
currency_denomination table could at the max have a
Robins Tharakan wrote:
Hi,
Now what I wanted to ask was whether its any different to have the
primary-keys in such master tables as text/varchar rather than integer ?
i.e. Can I use a character varying(10) and use the text 'million' /
'billion' instead of a serial / integer type ?
One shou
Robins Tharakan wrote:
Hi,
I am currently designing a database and wanted to know something that may
sound trivial, but I thought its still good to confirm before dumping
millions of rows in it.
The design requires a few master tables with very limited rows, for e.g.
currency_denomination table
