> I am going to write an application tht writes big amounts of plain text
into a database.
What kind of data are those? Articles? News/mail messages? Other?
> I thought of using the text type for this, but I don't know if it has a
maxlenght, and given that these will be very long texts I s
> 1. Speed
> 2. Data Reliability
The two above depend very much (IMHO) on SYSDBA's skills. IB and its
descendants has, probably, less options to tweak, or, more correctly, less
obvious ways to improve its performance.
OTOH, if you have strong theoretical RDBMS bacground and consider
> Also, if your pipe reader slows down too much, syslogd will start
> blocking on the pipe
Indeed.
> So I think it'd be much safer to
> have a flat text logfile and have your program read from that
Or send the data to DB backend only when the logs are rotated. As long
as the logs are kept sho
> I am not sure I understand the implications of the piping it to the
> insert
> routine.
It's a double-edged sword. Invoking it is as simple as adding a line to a
conf file, while developing it may turn out to be tricky. At least make
sure you examine output of ps ax to see how much
> Is there a way to automatically restart postgres after a failure 8)
/etc/inittab ?
--
ÌĤ¯Ç¤ÏÁͤòÊá¤é¤Ì
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
> Each user can have up to 4
> different mailing address. Is it better to have all this information in
> one table. Or is it better to have a user table and an address table,
> and have the user id as a foreign key in the address table?
It's even possible (recommended by the books) to have sepa
> that too is an option but it would hurt me to have to insert 20K record
> or
> something like that with a web browser.
H How ODBC driver is supposed to help with that? Upload a CSV or
FF file and run bulk insert with COPY.
> maybe because it is/was a deal between Apple and HK to b
> the only thing remaining to know is if
> there's PostgreSQL ODBC-like drivers for MacOS and/or applications able
> to
> work with PostgreSQL.
Not actually necessary. After all, make client part do what it's supposed
to- get user input and display server responses. Browser on Macs and
> Has anyone considered enabling truly globally unique identifiers (outside
of the data tree)? This could be done by concatenating the MAC Address(or
decimal equivalent) of Eth0 to generated OID's.
MAC Ethernet addresses aren't guranteed to be unique. On the other hand,
what if a host has no
Mike,
> Anyway, I crashed my system the other day when I did a "select *" from
> one
> of my large tables (about 5.5gb in size).
Well It takes abit more than that to actually crash the system. Can
you give more details? What _exactly_ happened? Did it hang? Kernel
panicked?
> As programmers, we naturally want to throw things into databases for
> three reasons. First, it's easy to get data in. Second, it's easy to get
> relevant data out. And third, it's "cool". We don't want to work with
> flat files, now do we? ; )
Kiddin', eh? :) Actually, the third re
> I could write a C function to turn FK into a text list, I suppose,
> or create some cast of arrays to tables/set of rows.
Sounds like a repetition group to me. Repetition groups are strictly
prohibited in relational systems. Check your design.
--
contaminated fish and microchips
hu
> I am looking for a way that I can archieve a lot e-mail messages to a
> data
> base. I'm thinking of using pgsql.
Been there, done that. Works OK for me. Desreves a major rewrite, because
storing message bodies as BLOBs is useless and dangerous. If only there
were 25 hours in the day
> But remember, that mysql doesn't have rules, triggers and such.
That's exactly what I mean when I suggest re-designing the schema from
scratch. Otherwise, you only get `a half of it.'
> I guess I could write a tool to select from mysql
> and insert into psql...
This can be easy, up to
> Conversion tools? Na, that's just a small part of what I do.
Since it's a network monitor, chances are you're not using exotic
datatypes incompatible, or non-existant in PGSQL? If so, the fastest way
would be to get a `dump' schema + data script from MySQL and adjust it with
sed or
15 matches
Mail list logo
