Hi,
Sorry for the slight delay in my response.
I am using 3 PostgreSQL databases and writing to them using an SQL proxy.
These databases have a high write volume. On rebooting all 3 servers for
OS/Software updates, i would like to figure out which was the last written
to DB (this is assuming th
On Mon, Jan 08, 2007 at 09:22:05 +0100,
Andy Dale <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Sorry for the slight delay in my response.
>
> I am using 3 PostgreSQL databases and writing to them using an SQL proxy.
> These databases have a high write volume. On rebooting all 3 servers for
> OS/Softwa
Ok.
The SQL Proxy i am using (HA-JDBC) has some limitations with regard to
getting it's "cluster" back into sync. If ha-jdbc uses the wrong DB (one
that has been out of action for a while) as the starting point for the
cluster it will then try and delete stuff from the other DB's on their
introd
hi,
i'm trying to register/install postgres ODBC driver on windowsME.
i've copied driver from winXP machine. this is one .dll file.
i would like to get it on the list in ODBC manager.
how can i register this file as ODBC driver on winME machine?
thanks
---(end of broad
am Mon, dem 08.01.2007, um 10:54:39 +0100 mailte riki folgendes:
> hi,
>
> i'm trying to register/install postgres ODBC driver on windowsME.
> i've copied driver from winXP machine. this is one .dll file.
> i would like to get it on the list in ODBC manager.
> how can i register this file as ODBC
2007/1/6, Maurice Aubrey <[EMAIL PROTECTED]>:
Clodoaldo wrote:
> But the main factor to push me in the file system direction is the
> HTTP cache management. I want the internet web clients and proxies to
> cache the images. The Apache web server has it ready and easy. If
> the images where to be
Hi All!
I have some old piece of code, that worked two years ago (Postgres
version 7.2, I think), but doesn't work within Postgres 8.1.4 now.
The story is, that I have a trigger on a table (business day
statistics), that is fired before insert; it updates another table
(detailed transaction log),
Hi: I want to create a simple web interface that lists table data, select
entries to add/delete/change table data from a table in postgres database.
Whatz the best and easiest way to do this? Wondering if there are any modules
or code out there already.
TIA
Ravi
___
Hello everybody,
In Oracle i use the command "connect by prior" and i need to use it in
PostgreSQL, what is the sintax?
Hi there,
I have a problem sorting a SQL result if I use DISTINCT ON.
I have a table "tblcomment" with these columns:
id (serial)
path (varchar)
created (timestamp)
title (varchar)
These records are in the table "tblcomment":
id pathcreated title
--
Hi,
On Mon, 2007-01-08 at 05:36 -0800, Ravi Malghan wrote:
> I want to create a simple web interface that lists table data, select
> entries to add/delete/change table data from a table in postgres
> database. Whatz the best and easiest way to do this?
You can use phpPgAdmin: http://www.phpPgAdmi
Nico Grubert <[EMAIL PROTECTED]> writes:
> My first try was this SQL query:
>
> SELECT DISTINCT ON (path) path, comment_id, created, title
> FROM bewertungen.tblcomments
>
> This does not allow me to append "ORDER BY created" since I can only sort on
> path because of DISTINCT ON (path).
I
Hi all,
We're currently developing some large-scale software with the intention
of selling it (online and off-the-shelf). The version in development uses
Postgres to store stuff in a number of large databases.
Ignoring potential licensing issues for now, the big issue for us is that
the data
Sorry about the typo in the title, of course I don't want to reverse
any engineering schemas. :)
I ended up using Squirrel SQL. (A tool I haven't used in a long time
and almost forgot about.)
http://squirrel-sql.sourceforge.net/
The diagraming part is not supersmart, but good enough for my purpos
hello,
postgresql uses bitmap indexing for indexing in databases.
*Is there any technique used*
* used to compress the bitmap indices in postgresql*,like oracle that uses
Byte Aligned bitmap compression to compress bitmaps.
regards,
sangeetha.
>>>apache has very good page and image caching. You could take advantage
>>>of that using this technique.
> I wonder why this HTTP cache headers argument didn't surface in this
> heated debate.
I did other up this argument by the way.
Andrew
Clodoaldo wrote:
2007/1/5, Jorge Godoy <[EMAIL PR
Clodoaldo wrote:
But the main factor to push me in the file system direction is the
HTTP cache management. I want the internet web clients and proxies to
cache the images. The Apache web server has it ready and easy. If
the images where to be stored in the DB I would have to handle the
HTTP cac
Title: Postgres Differential backup
Hi,
I do not kb=now how to take differential database backup in postgre 8.1.5.
Please help.
B. VijayaRam
Chennai.
DISCLAIMER:
---
T
Rafal Pietrak <[EMAIL PROTECTED]> writes:
> Hi All!
>
> I have some old piece of code, that worked two years ago (Postgres
> version 7.2, I think), but doesn't work within Postgres 8.1.4 now.
>
> The story is, that I have a trigger on a table (business day
> statistics), that is fired before ins
Clodoaldo wrote:
But the main factor to push me in the file system direction is the
HTTP cache management. I want the internet web clients and proxies to
cache the images. The Apache web server has it ready and easy. If
the images where to be stored in the DB I would have to handle the
HTTP cac
In response to "Vijayaram Boopalan - TLS , Chennai" <[EMAIL PROTECTED]>:
>
> I do not kb=3Dnow how to take differential=
> database backup in postgre 8.1.5.
What on Earth is wrong with your MUA?
See:
http://www.postgresql.org/docs/8.1/interactive/backup-online.html
--
Bill Moran
Collaborative F
pakt sardines wrote:
Hi all,
We're currently developing some large-scale software with the
intention of selling it (online and off-the-shelf). The version in
development uses Postgres to store stuff in a number of large databases.
Ignoring potential licensing issues for now, the big iss
It does allow you to sort on both columns.
SELECT DISTINCT ON (path) path, comment_id, created, title
FROM bewertungen.tblcomments ORDER BY path, created
Thank you very much. Works perfect! :-)
---(end of broadcast)---
TIP 3: Have you
There is no default support but you can always use connectby() function from
the tablefunc contrib module
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Leandro Repolho <[EMAIL PROTECTED]> wrote:
Hello everybody,
In Oracle i use the command "connect by prior" and
Bill Moran wrote:
> In response to "Vijayaram Boopalan - TLS , Chennai" <[EMAIL PROTECTED]>:
> >
> > I do not kb=3Dnow how to take differential=
> > database backup in postgre 8.1.5.
>
> What on Earth is wrong with your MUA?
This:
X-MimeOLE: Produced By Microsoft Exchange V6.5
It's fairly commo
thank you Tom!
that did the trick!
I'm still in the dark why my test data type didn't exhibit the
problem, but I'm certainly a much happier camper now.
Eric.
At 05:40 PM 05/01/2007, Tom Lane wrote:
Eric Davies <[EMAIL PROTECTED]> writes:
> Some of my custom server functions/data types that wo
I have jotted down some notes on performing a hot backup (which is what Bill
is referring you to), and I included a script called pg_hotbackup that
automates the relatively simple tasks required to take a snapshot of the
cluster data directory.
http://www.postgresqlforums.com/forums/viewtopic.php
sangeetha k.s wrote:
> hello,
>
> postgresql uses bitmap indexing for indexing in databases.
> *Is there any technique used*
> * used to compress the bitmap indices in postgresql*,like oracle that uses
> Byte Aligned bitmap compression to compress bitmaps.
Postgres does not support
On Mon, 2007-01-08 at 02:22, Andy Dale wrote:
> Hi,
>
> Sorry for the slight delay in my response.
>
> I am using 3 PostgreSQL databases and writing to them using an SQL
> proxy. These databases have a high write volume. On rebooting all 3
> servers for OS/Software updates, i would like to figu
On Mon, 2007-01-08 at 03:26, Andy Dale wrote:
> Ok.
>
> The SQL Proxy i am using (HA-JDBC) has some limitations with regard to
> getting it's "cluster" back into sync. If ha-jdbc uses the wrong DB
> (one that has been out of action for a while) as the starting point
> for the cluster it will then
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
> Hello everybody,
> In Oracle i use the command "connect by prior" and i need to use it in
> PostgreSQL, what is the sintax?
What does connect by prior do? Reuse a connection from one db to
another? I don't think there's anything like that in
It is used for Hierarchical queries in Oracle :)
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
> Hello everybody,
> In Oracle i use the command "connect by prior" and i nee
On 08.01.2007 17:24 Scott Marlowe wrote:
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
Hello everybody,
In Oracle i use the command "connect by prior" and i need to use it in
PostgreSQL, what is the sintax?
What does connect by prior do? Reuse a connection from one db to
another? I don
Tom Lane wrote:
Erik Jones <[EMAIL PROTECTED]> writes:
Before migrating to 8.2, even during peak times, unless queries were
seriously stacking (not completing in a timely manner), we'd see at most
50 - 100 queries active at any given time (we did have
stats_command_string = on). Since the
Scott Marlowe wrote:
On Mon, 2007-01-08 at 03:26, Andy Dale wrote:
Ok.
The SQL Proxy i am using (HA-JDBC) has some limitations with regard to
getting it's "cluster" back into sync. If ha-jdbc uses the wrong DB
(one that has been out of action for a while) as the starting point
for the clust
Hi,
I am still not so certain about adding a timestamp column to each table, as
within a few months the table will be quite big. My current thinking is to
have a trigger per table that overwrties a single value in a single utility
table after every write, this will be far quicker to select when
I have a column that is a varchar(6) I need to sort it by the rows that
are integers 1st then the character ones or vice versa, I just need the
values that can be converted to integer to sort by their numeric value.
i.e
1, 2, 3, 4, 5, 10, 11, A, B, C
instead of
1, 10, 11, 2, 3, 4, 5, A, B, C
An
On Jan 8, 2007, at 10:32 AM, Erik Jones wrote:
Erik Jones <[EMAIL PROTECTED]> writes:
One question regarding my previous thread about the 8.2 client
tools. We have yet to have time (personal as well as usage pattern
constraints) to dump our schema to analyze it for any possible
discrepe
On several occasions I have thought that each row in a table should have a
SYSTEM COLUMN which gave the timestamp of the last update of that row. This
could get a bit expensive on space and in some cases might be redundant with
(or have a slightly different value from) a user-maintained timestamp
Ah, I'd been looking at the following from Ch. 23.5 Backup and Restore
and was hoping it would go in both directions:
"It is recommended that you use the pg_dump and pg_dumpall programs from
the newer version of PostgreSQL, to take advantage of any enhancements
that may have been made in these
am Mon, dem 08.01.2007, um 10:21:38 -0600 mailte Bart McFarling folgendes:
> I have a column that is a varchar(6) I need to sort it by the rows that are
> integers 1st then the character ones or vice versa, I just need the values
> that
> can be converted to integer to sort by their numeric value
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> On Jan 8, 2007, at 10:32 AM, Erik Jones wrote:
>> One question regarding my previous thread about the 8.2 client
>> tools. We have yet to have time (personal as well as usage pattern
>> constraints) to dump our schema to analyze it for any po
Take a look at contrib/tablefunc there is a function called connectby()
that should do what you're looking for.
Otherwise roll your own...
http://archives.postgresql.org/pgsql-sql/2003-10/msg00374.php
John
Thomas Kellerer wrote:
On 08.01.2007 17:24 Scott Marlowe wrote:
On Mon, 2007-01-08 at
On mán, 2007-01-08 at 17:59 +0100, A. Kretschmer wrote:
> am Mon, dem 08.01.2007, um 10:21:38 -0600 mailte Bart McFarling folgendes:
> > I have a column that is a varchar(6) I need to sort it by the rows that are
> > integers 1st then the character ones or vice versa, I just need the values
> > t
Ragnar <[EMAIL PROTECTED]> schrieb:
> > test=*# select w, case when w ~ '^[0-9]*$' then w::int else 1 end from
> > foo order by 2,1;
>
> possible improvements:
> a) w ~ '^[0-9]+$'
> b) use NULL instead of 1
Thanks, right.
Andreas
--
Really, I'm not out to destroy Microsoft. That w
Thanks,
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andreas
Kretschmer
Sent: Monday, January 08, 2007 11:19 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sorting
Ragnar <[EMAIL PROTECTED]> schrieb:
> > test=*# select w, case when w ~ '^
is there a tracking trace tool in postgre? like the "SQL Analizer" in MS sqlserver.I have downloaded the PGAdmin III and i have not found any tool like this.Thanks Get your FREE, LinuxWaves.com Email Now! --> http://www.LinuxWaves.comJoin Linux Discussions! --> http://Community.LinuxWaves.com
On Sun, 2006-12-24 at 03:03, Christopher Browne wrote:
[snip]
> Seems to me that you could get ~80% of the way by having the simplest
> "2 queue" implementation, where tables with size < some threshold get
> thrown at the "little table" queue, and tables above that size go to
> the "big table" queu
Hello all,
When installing PostgreSQL via the Windows installer, Slony-I is one
of the options offered. Does it install the the Slony binaries, or
just the SQL scripts/functions that Slony uses?
Thanks,
Ray.
--
Raymond O'Do
It does install both the Slony binaries and scripts.
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
Hello all,
When installing PostgreSQL via the Windows installer, Slony-I is one
of the options offered. Does it install the
There is no GUI tool that I know of, but there is EXPLAIN which gives
the same information.
- Ian
On 1/8/07, guillermo arias <[EMAIL PROTECTED]> wrote:
is there a tracking trace tool in postgre? like the "SQL Analizer" in MS
sqlserver.
I have downloaded the PGAdmin III and i have not found any
Leandro Repolho wrote:
Hello everybody,
In Oracle i use the command "connect by prior" and i need to use it in
PostgreSQL, what is the sintax?
The last time I saw this discussed, Tom Lane referred to a "pg-hier"
modification but said this: "Beware that it makes an
incompatible change in rule r
On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
Not exactly. SQL Analyzer also includes live monitoring of whatever
queries are coming into the database. You can achieve something similar by
enabling query logging in the settings.
On 1/8/07, Ian Harding <[EMAIL PROTECTED]> wrote:
>
> The
On Mon, 2007-01-08 at 12:56 -0600, Jeffrey Melloy wrote:
>
>
> On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
> Not exactly. SQL Analyzer also includes live monitoring of
> whatever queries are coming into the database. You can
> achieve something similar by enabli
guillermo arias wrote:
is there a tracking trace tool in postgre? like the "SQL Analizer" in
MS sqlserver.
I have downloaded the PGAdmin III and i have not found any tool like this.
Thanks
Get your FREE, LinuxWaves.co
I thought that was called SQL Profiler.
http://msdn2.microsoft.com/en-us/library/ms181091.aspx
Query Analyzer is EXPLAIN with a GUI.
http://msdn2.microsoft.com/en-gb/library/aa178423(SQL.80).aspx
Anyway, I have not heard of such a thing for PostgreSQL, although I am
sure the basic information
Whoops, you're right.
On 1/8/07, Ian Harding <[EMAIL PROTECTED]> wrote:
I thought that was called SQL Profiler.
http://msdn2.microsoft.com/en-us/library/ms181091.aspx
Query Analyzer is EXPLAIN with a GUI.
http://msdn2.microsoft.com/en-gb/library/aa178423(SQL.80).aspx
Anyway, I have not hear
On 1/8/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
On Mon, 2007-01-08 at 12:56 -0600, Jeffrey Melloy wrote:
>
>
> On 1/8/07, Jeffrey Melloy <[EMAIL PROTECTED]> wrote:
> Not exactly. SQL Analyzer also includes live monitoring of
> whatever queries are coming into the database.
pakt sardines wrote:
> ...the big issue for us is
> that the data in the databases has significant intellectual property
> value. It has taken literally years of work to collect the data. We do
> not want the users of the commercial product to be able to fire up
> postgres and type something like
I am running postgres on Windows XP and have been for quite a while as
the database engine for our application.
On an ODBC connection the following error has started happening. The gap
in activity is normal for our application. but the connection failing is
a first we have this application liv
> > In Oracle i use the command "connect by prior" and i need to use it in
> > PostgreSQL, what is the sintax?
>
> I was unable to find pg-hier in a quick cruise through PgFoundry.
Try http://gppl.moonbone.ru/
The patch is not yet fixed to 8.2.0. 8.1.2 looks to be the latest.
Ian,
Query Analyzer is EXPLAIN with a GUI.
Anyway, I have not heard of such a thing for PostgreSQL,
On my installation of PostgreSQL from the stock windows installer
there was installed PgAdmin, which has quite a GUI for EXPLAIN.
The query plan is displayed very nice and I find it easier to
u
On Sat, Jan 06, 2007 at 11:14:42AM +1100, pakt sardines wrote:
>
>Hi all,
> We're currently developing some large-scale software with the
> intention of selling it (online and off-the-shelf). The version in
> development uses Postgres to store stuff in a number of large
> databases. Ignoring
> --- Original Message ---
> From: "Raymond O'Donnell" <[EMAIL PROTECTED]>
> To: pgsql-general@postgresql.org
> Sent: 1/8/07, 5:57:59 PM
> Subject: [GENERAL] Slony in Windows installer?
>
> Hello all,
>
> When installing PostgreSQL via the Windows installer, Slony-I is one
> of the opt
> --- Original Message ---
> From: "Ian Harding" <[EMAIL PROTECTED]>
> To: "Jeffrey Melloy" <[EMAIL PROTECTED]>
> Sent: 1/8/07, 7:06:31 PM
> Subject: Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer"
> in MS sqlserver.?
>
> I thought that was called SQL Profiler.
>
>
I'm just throwing this out here... but the usual suspects for strange
connection issues like these would be a software firewall or antivirus
(especially AV software that has anti-worm features).
Also, Windows XP Pro isn't really viable as a server OS as Microsoft has
intentionally limited certa
I've been using a product called HappyFish, which does reverse
engineering on Postgres and has proven to be a great DB development
tool. While it's not free, it is very low cost and you can easily get a
full-featured evaluation version to try out. I've been running it
through its paces with a pre
How long has that been available for OS X? Last time I looked at it it
wasn't.
On 1/8/07, Dave Page <[EMAIL PROTECTED]> wrote:
> --- Original Message ---
> From: "Ian Harding" <[EMAIL PROTECTED]>
> To: "Jeffrey Melloy" <[EMAIL PROTECTED]>
> Sent: 1/8/07, 7:06:31 PM
> Subject: Re: [GE
> --- Original Message ---
> From: "Jeffrey Melloy" <[EMAIL PROTECTED]>
> To: "Dave Page" <[EMAIL PROTECTED]>
> Sent: 1/8/07, 8:18:02 PM
> Subject: Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer
>
> How long has that been available for OS X? Last time I looked at it
Shelby Cain wrote:
I'm just throwing this out here... but the usual suspects for strange
connection issues like these would be a software firewall or antivirus
(especially AV software that has anti-worm features).
Also, Windows XP Pro isn't really viable as a server OS as Microsoft has
intent
Hello List!
OK, so I'm new to SQL and Postgres and am working on taking over this DB
work, and ran across a command that I'm not sure of and am wondering if you
can help me with... Probably a basic SQL question, but thought more than one
person on here would be able to point me in the right dire
If you are suffering from this particular error, you will see an entry
in the event log. Look for an error from Tcpip with an ID of 4226. The
message will say "TCP/IP has reached the security limit imposed on the
number of concurrent (incomplete) TCP connect attempts.". If you do not
see this me
Brandon Aiken wrote:
If you are suffering from this particular error, you will see an entry
in the event log. Look for an error from Tcpip with an ID of 4226. The
message will say "TCP/IP has reached the security limit imposed on the
number of concurrent (incomplete) TCP connect attempts.". If
Jeanna Geier wrote:
Hello List!
OK, so I'm new to SQL and Postgres and am working on taking over this DB
work, and ran across a command that I'm not sure of and am wondering if you
can help me with... Probably a basic SQL question, but thought more than one
person on here would be able to poin
If this is not the right list for this problem, could someone please
point me to the right area?
Curran Schiefelbein wrote:
Hi,
I'm trying to compile postgres-8.2.0 from source on WinXP-SP2, for use
with libpqxx.
At first I was able to compile in cygwin with ./configure followed by
make. How
On Mon, 2007-01-08 at 15:19, Curran Schiefelbein wrote:
> If this is not the right list for this problem, could someone please
> point me to the right area?
according to this page:
http://www.postgresql.org/community/lists/
"Current win32 development issues should be raised on -hackers. Cygwin
Try a 180-day Win2k3 trial to see if the issue persists. Realistically,
though, if you can't afford the proprietary software don't develop with
it.
If it's a Windows XP bug (or "feature") then it's not anything we can
help with since PG is working correctly.
--
Brandon Aiken
CS/IT Systems Engine
Hi,
I have approximately 2 billion data entries that I would like to insert into a
database.
Each entry consists of:
INT BOOLEAN INT BOOLEAN
I want to populate a table such that it only contains the unique rows, all
other data
should be thrown out. I would say a significant amount of the inser
On 8 Jan 2007 at 23:15, Shoaib Mir wrote:
> It does install both the Slony binaries and scripts.
Grand - thanks for confirming.
Ray.
--
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
[EMAIL PROTECTED]
On Mon, 2007-01-08 at 14:58, George Nychis wrote:
> Hi,
>
> I have approximately 2 billion data entries that I would like to insert into
> a database.
> Each entry consists of:
> INT BOOLEAN INT BOOLEAN
>
> I want to populate a table such that it only contains the unique rows, all
> other data
Scott Marlowe wrote:
> On Mon, 2007-01-08 at 14:58, George Nychis wrote:
>> Hi,
>>
>> I have approximately 2 billion data entries that I would like to insert into
>> a database.
>> Each entry consists of:
>> INT BOOLEAN INT BOOLEAN
>>
>> I want to populate a table such that it only contains the
On Mon, 2007-01-08 at 15:52, George Nychis wrote:
> Scott Marlowe wrote:
> > On Mon, 2007-01-08 at 14:58, George Nychis wrote:
> >> Hi,
> >>
> >> I have approximately 2 billion data entries that I would like to insert
> >> into a database.
> >> Each entry consists of:
> >> INT BOOLEAN INT BOOLEAN
Scott Marlowe wrote:
> On Mon, 2007-01-08 at 15:52, George Nychis wrote:
>> Scott Marlowe wrote:
>>> On Mon, 2007-01-08 at 14:58, George Nychis wrote:
Hi,
I have approximately 2 billion data entries that I would like to insert
into a database.
Each entry consists of:
>>>
On Mon, 2007-01-08 at 15:59, George Nychis wrote:
> Scott Marlowe wrote:
> > On Mon, 2007-01-08 at 15:52, George Nychis wrote:
> >> Scott Marlowe wrote:
> >>> On Mon, 2007-01-08 at 14:58, George Nychis wrote:
> Hi,
>
> I have approximately 2 billion data entries that I would like to
[EMAIL PROTECTED] (Csaba Nagy) writes:
> On Sun, 2006-12-24 at 03:03, Christopher Browne wrote:
> [snip]
>> Seems to me that you could get ~80% of the way by having the simplest
>> "2 queue" implementation, where tables with size < some threshold get
>> thrown at the "little table" queue, and table
> Note that things will go faster if you do your initial data load using
> "copy from stdin" for the initial bulk data load. individual inserts in
> postgresql are quite costly compared to mysql. It's the transactional
> overhead. by grouping them together you can make things much faster.
> cop
Jeremy Haile wrote:
>> Note that things will go faster if you do your initial data load using
>> "copy from stdin" for the initial bulk data load. individual inserts in
>> postgresql are quite costly compared to mysql. It's the transactional
>> overhead. by grouping them together you can make
Hello List!
I have a question regarding SELECT INTO...
Can it be used with Views? I have a View that is populated (~35,000 rows)
that I want to create a Table from the data in it
So, would I be able to copy the data from the View to the Table using the
SELECT INTO command?
Thanks much,
-J
> My point is: if I need to be 100% sure that what is referenced on the database
> is accessible all the time when the reference is, then I need to have this on
> the database
Not necessarily. It does take carefully controlling access, with a good deal
of thought and error-checking on the part of
Suppose I have a table - lets say it was developed by someone with little or no
understanding of database design - and it has 230 columns.
Now, it turns out that 99% of the time only about 8 colums are required, but
all 230 columns are populated. However, legacy applications (which are run
nig
Why not collect some information from live databases and perform some
analysis on it?
Possible values required for (to be defined) vacuum heuristic,
Human classification of tables,
Updates/Transactions done (per table/db),
Growth of tables and indexes,
(all with respect to time I believe)
Collect
On 1/9/07, Jeanna Geier <[EMAIL PROTECTED]> wrote:
Hello List!
I have a question regarding SELECT INTO...
Can it be used with Views? I have a View that is populated (~35,000 rows)
that I want to create a Table from the data in it
So, would I be able to copy the data from the View to the
Is it true that you can't use COPY FROM to fill a table with a SERIAL
type column?
Or rather, how does one approach that situation most effectively?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
Jeanna Geier wrote:
Hello List!
I have a question regarding SELECT INTO...
Can it be used with Views? I have a View that is populated (~35,000 rows)
that I want to create a Table from the data in it
So, would I be able to copy the data from the View to the Table using the
SELECT INTO com
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:
On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote:
Is it true that you can't use COPY FROM to fill a table with a SERIAL
type column?
Or rather, how does one approach that situation most effectively?
Could you give an example of what
On Jan 8, 2007, at 9:13 PM, Matthew Terenzio wrote:
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:
On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote:
Is it true that you can't use COPY FROM to fill a table with a
SERIAL type column?
Or rather, how does one approach that situation
On Jan 8, 2007, at 9:20 PM, Matthew Terenzio wrote:
On Jan 8, 2007, at 9:13 PM, Matthew Terenzio wrote:
On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:
On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote:
Is it true that you can't use COPY FROM to fill a table with a
SERIAL type co
John Sales <[EMAIL PROTECTED]> writes:
> By doing this, I'm hoping that the query optimizer is smart enough to see
> that if a query comes in and requests only the six columns (that are in the
> narrower table) that PostgreSQL won't have to load the wider table into the
> buffer pool, and thereb
Joris Dobbelsteen wrote:
> Why not collect some information from live databases and perform some
> analysis on it?
We already capture and utilize operational data from databases: for each
table, how many tuples there are, how many tuples have been inserted,
deleted, updated. We already analyse it
Bill Moran wrote:
> In response to "Vijayaram Boopalan - TLS , Chennai" <[EMAIL PROTECTED]>:
> >
> > I do not kb=3Dnow how to take differential=
> > database backup in postgre 8.1.5.
>
> What on Earth is wrong with your MUA?
For some reason I thought that was hilarious. :-)
--
Bruce Momjian
1 - 100 of 106 matches
Mail list logo