I am working on a project which needs me to implement the direct
“wired-protocol” to talk to pgsql. One side, I talk to pgsql, the other side, I
need to make a listener which accepts the protocol from pgsql’s and mysql’s
ODBC (talking wired to both). [sorry if Wired is not the correct term, that
A while back someone answered a question I was running into - poor performance
on count(*) from a table which is constantly growing. The answer was like
looking at oracle's V$ table - and I could get a semi-current count. (I do not
need the exact count - just checking to make sure the table is g
Is it possible (and how) to implement a data path on another partition (linux)
for an existing system? And then if I do not gain anything, merging it to the
production /data path?
Scenario of what I want to achieve (/mnt/data is already running)
/mnt/data resides on an NFS share
How/where do I query this?
My script does not need a 100% accurate count - just a recently valid count -
so I can verify the web crawlers are still crawling :-)
On Oct 27, 2010, at 7:15 AM, Merlin Moncure wrote:
> pg_class.reltuples
--
Sent via pgsql-general mailing list (pgsql-general@postg
I am the only user on this system right now, and one table select count(*) took
over 20 minutes:
wikitags exists and has 58,988,656 records.
Structure (in pascal) is:
quer.SQL.Add('create table '+DBTags+' (');
quer.SQL.Add(' pagename '+SQL_TITLE+'(100) not null,');
quer.SQL.Add(' t
27;,'journeyness')
or soundex2 in ('J650')
or metaphone in ('jrny')
or metaphone2 in ('JRN')
group by pagename,tagword,instances
order by tagword,instances desc,pagename
Giving it indexes for each of the "or" elements got the 8.8 million row
query dow
Good after everyone,
We are experiencing some performance issues on a table with 7 fields,
8,800,000 rows. During some exercises, one thing I noticed is I need to change
the configuration of the system to house pgsql_tmp on a host partition instead
of the drive array... that will get me
On Jun 25, 2010, at 10:48 AM, Scott Marlowe wrote:
> On Fri, Jun 25, 2010 at 7:10 AM, javijava wrote:
>>
>> Hi,
>>
>> i'm newby in postgre sql world.
>>
>> i need to know how to do a simple script that create a database,the y
>> select it (in other languajes using USE) and after create table
I found a page:
http://www.postgresql.org/docs/8.3/static/uuid-ossp.html
Is that the only way to get UUID from postgresql?
* We are in the midst of porting a replication product to support postgresql,
which relies on UUID/GUID for uniqueness instead of Sequences and Site ID's.
Thanks,
Lost me a bit, do you mean DISTINCT?
select distinct state1, first(timestamp) from table
On May 27, 2010, at 10:04 AM, Nikolas Everett wrote:
> Say I have a table that stores state transitions over time like so:
> id, transitionable_id, state1, state2, timestamp
>
> I'm trying to write a qu
I dont think its that easy. 50,000 sockets open, sure, but whats the
performance? The programming model has everything to do with that,
and windows select() wont support that many sockets with any sort of
performance. For windows you have to convert to using non-blocking
sockets w/messages
On 4/29/10 12:42 PM, Greg Smith wrote:
Alban Hertroys wrote:
The reason I'm asking is that Postgres doesn't perform at its best on
Windows and I seriously wonder whether the OS would be able to handle
a load like that at all (can Windows handle 4000 open sockets for
example?).
You have to g
I am trying to get that combination to work, without success.
I am running Mac Snow Leopard on my development machine and cannot find
anyone who has gotten ceOBDC and libiodbc to work - so I want to ask you
guys.
Thanks,
O.
--
Thank you,
G.E. Ozz Nixon
CEO/Sr. Software Architect
3F, LLC
Would this syntax work in PostgreSQL?
|INSERT INTO MyTable (FirstCol, SecondCol)
VALUES ('First',1),
|| ('||Second||',2),|
| ('||Third||',3),|
| ('||Fourth||',4),|
| ('||Fifth||',5)||
|
Inserting 5 rows in a single Insert? (I am trying to implement this
solution across many different backends) w
should be looking at for true master-master?
Thanks,
O.
--
Thank you,
G.E. Ozz Nixon
CEO/Sr. Software Architect
3F, LLC
125 Robin Dr.
Barto PA 19504
Office: 1-484-363-2304
Cell: 1-610-698-7976
Email: o...@3flabs.com
The information contained in this communication is confidential. It is intended
On 3/26/10 11:12 AM, John Gage wrote:
As a kind of [very?] dumb question, is this where SQLite has been
used? I am just curious.
All questions are good ones, as that is how we all learn. ;-)
SQLite is useful for small foot print environments, along with simpler
solutions like XBase (DBase) f
On 3/26/10 10:06 AM, Alan McKay wrote:
On Thu, Mar 25, 2010 at 4:15 PM, Scott Marlowe wrote:
These questions always get the first question back, what are you
trying to accomplish? Different objectives will have different
answers.
We have a real-time application that processes data a
guidance you guys can give me!
Ozz
Thank you,
G.E. Ozz Nixon
CEO/Sr. Software Architect
3F, LLC
125 Robin Dr.
Barto PA 19504
Office: 1-484-363-2304
Cell: 1-610-698-7976
Email: o...@3flabs.com
The information contained in this communication is confidential. It is
intended only for the use of the
s found in 3.00 ms.
SQL>
On Mar 2, 2010, at 8:30 PM, Ozz Nixon wrote:
I do not know how to really describe this...
In pascal I would do
If (AField and Flag3)=Flag3 then ...
Checking to see if AField contains the BIT(s) FLAG3 is set to... is
there a way to do this in a SELECT
I do not know how to really describe this...
In pascal I would do
If (AField and Flag3)=Flag3 then ...
Checking to see if AField contains the BIT(s) FLAG3 is set to... is
there a way to do this in a SELECT statement -- select * from ATable
where AField and 0x0004=0x0004
?
Thanks,
Hello,
I have been experimenting with the product, nicely done! I would like
to implement it in a live scenario now, however, I have questions.
I have 2 Data Centers, 1 with 2 ISPs and 1 with 1 ISP. I would like to
setup the product to replicate from 1 center to another - as close to
rea
21 matches
Mail list logo
