Shane wrote:
> No - a *core* is another cpu, basically you will have 2 or 4 cpu's in
> the one physical package.
>
> HT creates 2 virtual cpu's sharing the same cpu resources but the
> cores are seperate cpu's in themselves.
>
> The Quad-core will only benefit you more if you have more users
>
roopa perumalraja wrote:
> Hi Adam,
>
> Thanks a lot for your immediate reply. can you please tell me how to use
> the command pg_dump to backup specific tables. Thanks a lot in advance.
pg_dump --help
>
> Regards
> Roopa
>
> Adam Rich <[EMAIL PROTECTED]> wrote:
> Roopa,
>
Hi Adam,
Thanks a lot for your immediate reply. can you please tell me how to use the
command pg_dump to backup specific tables. Thanks a lot in advance.
Regards
Roopa
Adam Rich <[EMAIL PROTECTED]> wrote:
Roopa,
You can use the command pg_dump to backup specific tables.
Roopa,
You can use the command pg_dump to backup specific tables. But you
won't be able to
restrict the backup to specific rows. (You can always create a separate
table just for backups,
and dump just that table).
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Hi all,
Is it possible to back up only part of my database for example from tables
which have data from April to July 2006, if so what will be the command for
that.
Thanks a lot in advance
Roopa
-
It's here! Your new message!
Get new email alerts w
I am having trouble with to_tsquery when the query is all stop words.
Rather than return everything as a match, it returns nothing with the
notice:
NOTICE: Query contains only stopword(s) or doesn't contain lexem(s), ignored
What is the best way to check for this, I was hoping to be able to
che
Hi All,
We have an intermittent problem where PQexec does not seem to return
even though the server seems to have sent the results.
From the gdb output , the sql statement can be seen, and from the log,
the result can be seen to be sent. Both process are running on the same
machine. Versio
Guy Rouillier <[EMAIL PROTECTED]> writes:
> Does the spec leave implementation of indexes on the substr() function
> less than one undefined?
SQL99 defines the result of
::=
SUBSTRING FROM
[ FOR ]
as
a) Let C be the value of th
> "Marcel Gsteiger" <[EMAIL PROTECTED]> writes:
> > Sometimes I wish there was something like a debugger for PL/PGSQL with
> > breakpoints, single step, variable watching...
>
> Take a look at http://pgfoundry.org/projects/edb-debugger/
> ... it's beta but without users it won't get better.
>
> T
"Marcel Gsteiger" <[EMAIL PROTECTED]> writes:
> Sometimes I wish there was something like a debugger for PL/PGSQL with
> breakpoints, single step, variable watching...
Take a look at http://pgfoundry.org/projects/edb-debugger/
... it's beta but without users it won't get better.
The front page sa
Simon Riggs wrote:
On Fri, 2006-12-29 at 20:25 -0300, Alvaro Herrera wrote:
Christopher Browne wrote:
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
Does the spec leave implementation of indexes on the substr() function
less than one undefined? By mistake, I had a substr() invocation with
an initial index of zero (would be nice if all the computer languages of
the world could agree to a single definition.) Oracle silently treats
this the
On Wed, Jan 10, 2007 at 10:43:46PM +0100, Martijn van Oosterhout wrote:
> On Tue, Jan 09, 2007 at 10:39:05PM -0800, kmohan wrote:
> > I am trying to export my spatial data from postgres to shae using pgsql2shp
> > command.
> > When i keyed in the syntax pgsql2shp -f pl dcmms plss
> > It is showing
On Fri, Jan 12, 2007 at 10:58:36PM +0100, Martijn van Oosterhout wrote:
> On Fri, Jan 12, 2007 at 10:16:22PM +0100, Jiří Němec wrote:
> > I would like to remove diacritical marks from a string in a SQL query.
> > I tried to convert a UTF8 string to ASCII but it doesn't work for me.
> >
> > SELECT
PostgreSQL handles each connection in a dedicated process, so you won't get
better performance for a single connection by adding more CPUs (I mean,
beyond the benefit of having the postmaster and the specific connection
running in separate CPUs). This means that a query will not be resolved by
Tom Lane a écrit :
> =?UTF-8?B?U3TDqXBoYW5lIFNjaGlsZGtuZWNodA==?= <[EMAIL PROTECTED]> writes:
>
>> My goal is to migrate to 8.2.1. definitely. But as you said it, I do not
>> want to recreate unwanted index when migrating. I want to drop them BEFORE.
>> But, I can't just do a "drop index" comman
You can give EnterpriseDB PL Debugger a try, details for its usage can be
found at --> http://www.enterprisedb.com/documentation/debugger.html
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/14/07, Marcel Gsteiger <[EMAIL PROTECTED]> wrote:
thanks for responding. Meanwhile I
thanks for responding. Meanwhile I found out that ist was my own fault. A newly
installed insert trigger fired unexpectedly and caused the error. Now I'm
redesigning my functions to make them smaller so that errors can be found
easier. Sometimes I wish there was something like a debugger for PL
This is how version below 8.2 used to handled backslashes, but with 8.2 you
can now handle the backslashes using a setting in the postgresql.conf file:
standard_conforming_strings (boolean)
This controls whether ordinary string literals ('...') treat backslashes
literally, as specified in the SQL
select version()
"PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.3.5 (Gentoo
Linux 3.3.5-r1, ssp-3.3.2-3, pie-8.7.7.1)"
I have a table with UNC filename values (windows), such as
\\server\dir\fname.txt
I am running a like query to find all files on a spec
20 matches
Mail list logo
