On Fri, Nov 28, 2008 at 11:20 PM, Siddharth Shah
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am compiling postgres, I have some doubts on ./configure options
>
> --enable-nls[=LANGUAGES] enable Native Language Support
> Do I need to supply each language name which i am going to store in my
> da
Hi,
I am compiling postgres, I have some doubts on ./configure options
--enable-nls[=LANGUAGES] enable Native Language Support
Do I need to supply each language name which i am going to store
in my database or just have to take support UTF-8 ?
and
--disable-largefile
Does
>If I understand well you say that I could isolate data by using separate
group roles for each firms and defining updatable views to work on.
yes. it's one way to do it.
As simple as this example is, you might as well make a seperate table for
each firm. Then you wouldn't need to bother with views
"Robert Haas" <[EMAIL PROTECTED]> writes:
> It seems very strange for the planner to decide to build an in-memory
> hash table on a column that is already indexed (the primary key, no
> less!).
What's strange about it? A probe into an in-memory hashtable is a lot
cheaper than a probe into an inde
> I'm seeing a lot of plans in my database that look like this:
> It seems very strange for the planner to decide to build an in-memory
> hash table on a column that is already indexed (the primary key, no
> less!). But this is happening A LOT - I often see plans where a
> majority of the joins ar
I'm seeing a lot of plans in my database that look like this:
portal=# explain select * from foo i, foo j where i.id = j.id;
QUERY PLAN
-
Hash Join (cost=769.87..2159.36 rows=13283 width=264)
Grzegorz Jaśkiewicz wrote:
true, if you don't want to search on values too much ,or at all - use
float[]. But otherwise, keep stuff in a tables as such.
It might be humongous in size, but at the end of the day - prime thing
when designing a db is speed of queries.
If he's worried about speed
On Fri, Nov 28, 2008 at 5:46 PM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>
> I would look carefully at the number of bits required for each float
> value. 4 bytes is the default, but you may be able to use less bits than
> that rather than rely upon the default compression scheme working in
> your f
On Fri, 2008-11-28 at 15:40 +, William Temperley wrote:
> Hi all
>
> Has anyone any experience with very large tables?
>
> I've been asked to store a grid of 1.5 million geographical locations,
> fine. However, associated with each point are 288 months, and
> associated with each month are 5
2008/11/28 William Temperley <[EMAIL PROTECTED]>
>
> Any more normalized and I'd have 216 billion rows! Add an index and
> I'd have - well, a far bigger table than 432 million rows each
> containing a float array - I think?
>
> Really I'm worried about reducing storage space and network overhead
>
William Temperley escribió:
> Really I'm worried about reducing storage space and network overhead
> - therefore a nicely compressed chunk of binary would be perfect for
> the 500 values - wouldn't it?
An array that large would likely be compressed by Postgres internally
for storage; see
http://w
Really I'm worried about reducing storage space and network overhead
- therefore a nicely compressed chunk of binary would be perfect for
the 500 values - wouldn't it?
For storage space you might want to look at ZFS with compression on in
case you are using FreeBSD or Solaris.
That would s
Its located in Application Data folder.
Date: Thu, 27 Nov 2008 21:12:23 -0800From: [EMAIL PROTECTED]: Re: [ADMIN]
PgAgent Job Scehduler is NOT runningTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]:
pgsql-general@postgresql.org
I searched but didn't find any pgpass.conf file.
From: Vishal Arora
Daniel Chiaramello <[EMAIL PROTECTED]> writes:
> I am using Postrges 8.3.5, and I am trying to install a bulgarian ISpell
> dictionary (the OpenOffice one) for Textsearch features.
I'm not an expert, but I think our ispell code supports only a subset of
the features that some other implementation
On Tue, Nov 25, 2008 at 04:19:27PM +0300,
Dr.ONE <[EMAIL PROTECTED]> wrote
a message of 22 lines which said:
> I have database in KOI8-R encoding. ... ERROR: character 0x8b9a of
> encoding "MULE_INTERNAL" has no equivalent in "WIN1251"
Are you sure it is KOI8? The KOI8 encoding is monobyte and
Thanks for the reply Chris,
None of these are a problem for me because we are not using them at all...
Thanks again,
Ioana
--- On Thu, 11/27/08, Chris Browne <[EMAIL PROTECTED]> wrote:
> From: Chris Browne <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] Using postgres.log file for replication
On Fri, Nov 28, 2008 at 3:48 PM, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> William Temperley escribió:
>> So a 216 billion row table is probably out of the question. I was
>> considering storing the 500 floats as bytea.
>
> What about a float array, float[]?
I guess that would be the obvious cho
Hi Scott,
Thanks for the replay,
It is almost impossible to use any of the replication tools mostly because the
2 dbs are not on the same network (live and testing environments)... I don't
intend to use this for high availability. I am using Sequoia and PITR for
that...
I only intend to use
On Fri, Nov 28, 2008 at 3:48 PM, Alvaro Herrera
<[EMAIL PROTECTED]>wrote:
> William Temperley escribió:
>
> > I've been asked to store a grid of 1.5 million geographical locations,
> > fine. However, associated with each point are 288 months, and
> > associated with each month are 500 float values
On Friday 28 November 2008 3:47:10 am Stéphane A. Schildknecht wrote:
> drop table commande cascade;
> drop table commandeligne;
>
> CREATE TABLE commande
> (
> id integer NOT NULL,
> montant real,
> CONSTRAINT id PRIMARY KEY (id)
> )with oids;
>
> CREATE TABLE commandeligne
> (
> id_comman
William Temperley escribió:
> I've been asked to store a grid of 1.5 million geographical locations,
> fine. However, associated with each point are 288 months, and
> associated with each month are 500 float values (a distribution
> curve), i.e. 1,500,000 * 288 * 500 = 216 billion values :).
>
>
On Thursday 27 November 2008 8:17:10 pm Александър Шопов wrote:
> Hi everyone,
> In pg 8.2 to 8.3 transition there is a new behavior: Non-character data
> types are no longer automatically cast to TEXT
>
> I understand the reasons, however while we manage to migrate the our
> system, is there a way
Hi all
Has anyone any experience with very large tables?
I've been asked to store a grid of 1.5 million geographical locations,
fine. However, associated with each point are 288 months, and
associated with each month are 500 float values (a distribution
curve), i.e. 1,500,000 * 288 * 500 = 216 bi
On Thu, Nov 27, 2008 at 02:34:17AM +0900,
Craig Ringer <[EMAIL PROTECTED]> wrote
a message of 188 lines which said:
> > ERROR: character 0xc3bd of encoding "UTF8" has no equivalent in "WIN1251"
>
> Which it does not; that character is "???" (HANGUL SYLLABLE SSYEG)
No, I don't think so. I th
Hello everybody.
I am using Postrges 8.3.5, and I am trying to install a bulgarian ISpell
dictionary (the OpenOffice one) for Textsearch features.
I converted the dictionary encoding to UTF-8, and I installed it in the
"tsearch_data" folder.
But when I try to create the dictionary, I have a
Hi Julius-san.
Is this helpful?
http://libpqwce.projects.postgresql.org/
However, I'm busy and work has stagnated.
Regards,
Hiroshi Saito
- Original Message -
From: "Julius Tuskenis" <[EMAIL PROTECTED]>
To:
Sent: Friday, November 28, 2008 10:07 PM
Subject: Re: [GENERAL] pglib.dl
Sorry - its libpq.dll
Julius Tuskenis
Julius Tuskenis rašė:
Hello List,
I'm writing a program to be run on WinCE. Are there dll's for wince
client (pglib.dll and others)?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://w
-- Forwarded message --
From: elekis <[EMAIL PROTECTED]>
Date: Fri, Nov 28, 2008 at 12:53 PM
Subject: Re: [GENERAL] [NOOB] try tu put a number with pqexecprepare
To: Daniel Verite <[EMAIL PROTECTED]>
thanks for everything (and sorry for my english :D)
a++
On Fri, Nov 28, 2008 at
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I'm faced with something like a comprehension problem.
The exemple may be oversimplified, but, it seems same problem happens with
updates.
To simplify, I have triggers on 2 tables (commande and commandeligne).
When deleting from table commande,
Hi,
I am in the process of designing a distributed application (Java EE 5)
which has demand for database functionality at several points. Some of
these databases need to provide really mission critical reliability,
i.e. it would be the end of our world, if we would suffer from data
loss or silent
oh, and :
revoke all on table1 from public;
revoke all on view_firm1 from public;
revoke all on view_firm2 from public;
duh
--
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw
elekis wrote:
by the way,
I use cl.exe (windows) and he say
Cannot open include file: 'netinet/in.h': No such file or directory
is there any options compiles?? or other include ??
For windows, I'm using this:
#include
and it appears to be good enough.
You may have to include the
hey folks,
browsing psql source,I came across one of the variations of \list / -l
option, that could also print database size, which would be quite nice. But
that only seem to work in 'verbose' mode. Now, how can I turn that mode on
on command line, psql -lv doesn't do ;>
--
GJ
>
> I simply try to put the number 5 for the second column, and after that
>
read the line.
I just wanna put number in the db.(sniff)
To put 5 in your database use either a text of numeric datatype for your
column.
> I use cl.exe (windows) and he say
>
Cannot open include file: 'netinet/in.h':
On Fri, Nov 28, 2008 at 11:04 AM, Willy-Bas Loos <[EMAIL PROTECTED]> wrote:
> Only, it's too bad that you can't update the records from the "view data"
> dialog.
> It works in access2000, it doesn't know the difference between views and
> tables (the difference is actually very small).
> You probab
>
> I symply try to put the number 5 for the second column, and after that
>
read the line.
I just wanna put number in the db.(sniff)
To put 5 in your database use either a text of numeric datatype for your
column.
> I use cl.exe (windows) and he say
>
Cannot open include file: 'netinet/in.h':
Only, it's too bad that you can't update the records from the "view data"
dialog.
It works in access2000, it doesn't know the difference between views and
tables (the difference is actually very small).
You probably get some annoying error when you try to edit a normal select
view from access, thou
On Fri, Nov 28, 2008 at 11:48 AM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 28/11/2008 10:40, elekis wrote:
>
>> I just wanna put number in the db.(sniff)
>
> ROFOL!
be my guess :D
by the way,
I use cl.exe (windows) and he say
Cannot open include file: 'netinet/in.h': No such file or d
On 28/11/2008 10:40, elekis wrote:
> I just wanna put number in the db.(sniff)
ROFOL!
I can't help you with your problem, but you've made my morning!
:-)
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EM
hi, and thanks
something, I don't underdstand, a little research on google say to me
that htonl and...is in
#include a network stuff is that normal that I have to
use that???
I just wanna put number in the db.(sniff)
thanks
a++
On Fri, Nov 28, 2008 at 11:23 AM, Daniel Verite <[EMAIL P
elekis wrote:
I put the code here
http://pastebin.com/m1860cc27
I symply try to put the number 5 for the second column, and after
that
read the line.
but the database, I have taht
83886080 in place of 5.
83886080 happens to be ntohl(5), it's probably not a coincidence :)
Since
That's it!
Arora your document
(http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc) is better than
the best. The error was of postgress user rights and nothing else. After
granting rights to postgres Its really running well.
Thanks.
From: Vishal A
hi,
I try to use postgresql with a simple example using parameter, (so
with pqprepare and pqexecprepare).
I have trouble to put number.
I put the code here
http://pastebin.com/m1860cc27
I symply try to put the number 5 for the second column, and after that
read the line.
but the database, I
how about this:
create role firm1 nologin;
create role john password 'secret' login;
grant firm1 to john;
create role firm2 nologin;
create role amy password 'secret' login;
grant firm2 to amy;
create table table1 (id serial primary key,firm integer, val integer);
insert into table1 (firm, val)
44 matches
Mail list logo
